recid and rowid

skevin.john

New Member
Hello,
whats the fastest way to return a record using recid and rowid
?

I tried the following but its takin more time to give the output on the screen.


find product where string(recid(product)) = "5446546464787" no-lock no-error.
disp product with 2 col


Please help me with examples for both recid and rowid
 

TomBascom

Curmudgeon
If you have a RECID then:

find tableName where recid( tableName ) = 123456789 no-lock no-error.

is the fastest method. The naked RECID is all you need -- no conversions to and from strings.

Your code above is scanning the whole table converting the recid of each record to a string and then comparing it to the quoted string. That will be brutally painful.
 
Top