Get a record by RecordNumber from a table

[Bart Pietercil]

Hi Irv

...where [t1.] recid = ....

hth

Bart
On 25 Sep 2008, at 18:50, Irv Kalb wrote:

> 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
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina