SQLMemTable: BDE Alternative Embedded
In-Memory Database with SQL for Delphi / C++Builder
Inserts a new, populated record to the dataset and posts it to the database.
procedure InsertRecord(const Values: array of const);
Call InsertRecord to create a new, empty record at in the dataset, populate it with the field values in Values, and post the values to the database.
A newly inserted record is posted to the database in one of three ways:
|·||For indexed Paradox and dBASE tables, the record is inserted into the dataset in a position based on its index.
|·||For unindexed Paradox tables, the record is inserted into the dataset at the current cursor position.
|·||For unindexed dBASE, FoxPro, and Access tables, the record is inserted into the dataset at the end.
|·||For SQL databases, the physical location of the insert is implementation-specific. For indexed tables, the index is updated with the new record information.
The newly inserted record becomes active.