recid and rowid


New Member
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


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.