TDataSet.Insert TDataSet

Top

Inserts a new empty record into the dataset.

procedure Insert;

Description
Call Insert to:

1   Open a new, empty record in the dataset.

2   Set the active record to the new record.

After you call Insert, the application enables you to enter data into the fields of the record, and then post those changes to the database using Post (or ApplyUpdates if cached updating is enabled). The newly inserted record is posted to the database in one of three ways:

·

For Paradox tables with primary indexes, the record is inserted into the dataset in a position based on its index.

·

For Paradox tables without primary indexes, the record is inserted into the dataset at the current cursor position.

·

For dBASE, FoxPro, and Access tables, the record is physically appended to the dataset at the end. If an index happens to be active, the new record may appear in a position relative to the index, but the record is still actually stored at the end of the table.

·

For SQL databases, the physical location of the insert is implementation-specific. For indexed tables, the index is updated with the new record information.