topic-20288

goosfancito

Posts: 1956

Joined: Fri Oct 07, 2005 07:08 PM

How i do to find in RecordSet?
Posted: Tue Nov 16, 2010 03:52 PM

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.

FWH 21.02
Harbour 3.2.0dev (r2104281802)
Copyright (c) 1999-2021, https://harbour.github.io/

Adolfo

Posts: 883

Joined: Tue Oct 11, 2005 11:57 AM

Re: How i do to find in RecordSet?
Posted: Tue Nov 16, 2010 08:53 PM

Goosfancito

Try doing a orcs:movefirst() before calling FIND

Greetings from Chile

Adolfo

;-) Ji,ji,ji... buena la cosa... "all you need is code"

http://www.xdata.cl - Desarrollo Inteligente
----------
Asus TUF F15, 32GB Ram, 2 * 1 TB NVME M.2, GTX 1650

Enrico Maria Giordano

Posts: 9020

Joined: Thu Oct 06, 2005 08:17 PM

Re: How i do to find in RecordSet?
Posted: Tue Nov 16, 2010 08:54 PM

Try also

Code (fw): Select all Collapse

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

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

goosfancito

Posts: 1956

Joined: Fri Oct 07, 2005 07:08 PM

Re: How i do to find in RecordSet?
Posted: Tue Nov 16, 2010 09:17 PM

continue with error!

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

FWH 21.02
Harbour 3.2.0dev (r2104281802)
Copyright (c) 1999-2021, https://harbour.github.io/

Enrico Maria Giordano

Posts: 9020

Joined: Thu Oct 06, 2005 08:17 PM

Re: How i do to find in RecordSet?
Posted: Wed Nov 17, 2010 10:48 AM

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

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

Rick Lipkin

Posts: 2706

Joined: Fri Oct 07, 2005 01:50 PM

Re: How i do to find in RecordSet?
Posted: Wed Nov 17, 2010 02:42 PM

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

Rick Lipkin

FiveTech Support Forums

Continue the discussion