TMedDataset.Sequenced TMedDataset

property Sequenced: Boolean ;

Description

Set Sequenced to true if you wish the RecNo property to return the logical record number in the dataset, taking into account active index, range/scope and active server (SQL) filters. This can be important for proper scroll-bars management in browse components.

Even if Sequenced is false, the table is sequenced (see IsSequenced method) if no indexes or SQL filters where activated. In this case RecNo property returns physical record number, which is identical to logical record number.

If you activate any index or SQLFilter while Sequenced is false, RecNo property continues to return physical record number and the table becomes not sequenced (IsSequenced returns false). To make it sequenced, you should set Sequenced property to true. This will force recNo, to return logical record number instead of physical.