How to move to a record number
How do I move to a physical record. In Halcyon 5 there was a GoTo() command.
Use RecNo: MyTable.RecNo := 100;
This is the 'standard' command descended from TDataSet. The RecNo property both gives you the current record number (TheRecNo := MyTable.RecNo) and allows you to move to a new record (MyTable.RecNo := TheRecNo).

