How i do to find in RecordSet?

[goosfancito]

Hi!,
I need find value in a recordset.

oRs:Find( "CliDes LIKE '"+cBuscar+"*'",,1)

When i run my aplication it show error:

ADODB.RecordSet/6 DISP_E_UNKNOWNNAME: FIND
Args:
[ 1] = C cliDes LIKE 'd*'
[ 2] = U
[ 3] = N 1

Pueden por favor darme una mano. gracias.

[Adolfo]

Goosfancito

Try doing a orcs:movefirst() before calling FIND


Greetings from Chile

Adolfo

[Enrico Maria Giordano]

Try also

Code: Select all  Expand view

oRs:Find( "CliDes LIKE '"+cBuscar+"%'",,1)

EMG

[goosfancito]

continue with error!

i try with movefirst before.
i try with change * for %

[Enrico Maria Giordano]

Please take the time to make a reduced and self-contained sample yet showing the problem.

EMG

[Rick Lipkin]

Just an obvious question .. you are defining CliDes in your Select statement ? as in Select field1,field2,field3,CliDes .... or Select * ??

Rick Lipkin