Get a record by RecordNumber from a table

[Irv Kalb]

recid - that's the keyword I was missing.  (I kept looking for 
record<something>).

Works perfectly.

Thanks Bart!

Irv

At 7:20 PM +0200 9/25/08, Bart Pietercil wrote:
>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
>
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina


-- 

Multimedia R Us