Get a record by RecordNumber from a table

[Irv Kalb]

I'm sure I read this in the documentation somewhere, but I can't seem 
to find it now.

I have a table, say MyTable, and I want to able to get record number 
n (all fields) from the table.    What is the syntax for getting a 
record by its record number?  I'm hoping that there is something like:

DB.SqlQuery(SELECT * FROM MyTable WHERE recordNumber = " & string(n))

Is there anything like this?

Irv
-- 

Multimedia R Us