oRs:Find

[Lisa Giordano]

Ciao a tutti,
ho provato questo codice per una ricerca in un file MDB:

cFind:="K"
oRs:MoveFirst()

Reg:=oRs:Find("Campo1='"+cFind+"'")

msginfo(Reg)

oRs:Absoluteposition:=Reg

il valore restituito in Reg è uguale a nil
dove sbaglio?
Grazie

[nageswaragunupudi]

Sample code :

Code: Select all

oRs:Find( cSeekExpr, 0, 1, 1)
if oRs:eof()
   lFound   := .F.
   oRs:MoveLast()
else
   lFound   := .T.
endif
 

oRs:Find always returns nil. If find is successful, it goes to the first row found. If not it goes to eof.

Syntax:
objRecordset:Find( criteria, skiprows, direction, start )

[Armando]

Lisa:

Try this way

Reg:=oRs:Find("Campo1= " + "'" + cFind + "'")

Regards

[Lisa Giordano]

Reg restituisce sempre NIL

[Lisa Giordano]

if !oRs:eof() la ricerca ha esito positivo...

nTessera:="0100141411283"
oRs:MoveFirst()

oRs:Find( "CODTES='"+nTessera+"'", 0, 1, 1)
if !oRs:eof()
msginfo(oRs:Fields("CodTes"):Value)
endif

Grazie del suggerimento

[Lisa Giordano]

oRs:Sort :="CodTes"
da errore
Help me

[Armando]

Lisa:

Please review my spanish blog.

http://sqlcmd.blogspot.com/

All about ADO & MySql.

Regards

[nageswaragunupudi]

>
oRs:Sort :="CodTes"
>
This is correct. Please check your spellings and make sure the field name exists in the recordset.
what error are you getting ?