Advantage .NET Data Provider
Gets or sets the current record number.
public int RecordNumber{ get; set; }
Each physical record in a table has a record number. The first physical record is number 1. All records, even deleted ones (in DBF tables), have record numbers. The only way to change record numbers in a table is to perform a PackTable.
RecordNumber ignores filters, indexes, and scopes. It sets the physical record number even if an index is active. If set to zero or a number greater than the total number of records, the client will be unpositioned (EOF and BOF will be set) and the current record number will be set to 0.
Note If setting the RecordNumber property and using the AdsExtendedReader.Read method, the Read method will skip FROM the record number that was set using the RecordNumber property, which means values read will be from the next record in the dataset, not the record explicitly set via RecordNumber.
See Also