TMedTable.IsSequenced TMedTable

function IsSequenced: Boolean; override;

Description

Check IsSequenced to determine whether table records can be located by RecNo numbers. If IsSequenced is true you can go directly to the specific record number and all table records are logically numbered from 1 to RecordCount.

If no index and no SQLFilter is active, the table is always sequenced and the record order is the same as determined by RecNo numbers.

If there is an active index and/or SQLFilter, the table is not sequenced by default. While you still can use RecNo numbers to access any record from 1 to RecordCount, the record order will not be the same as RecNo numbers. Set Sequenced property to true to ensure RecNo numbers are the same as record order when there is an active index or SQLFilter. This may be important for scrollbar handling while index or filter is active.

Never set Sequenced to true if you don't really need it. Maintaining logical record numbers for ordered table can considerably slow down all operations requiring record numbers.