TCustomDADataSet.KeyFields Property

Used to build SQL statements for the SQLDelete, SQLInsert, and SQLUpdate properties if they were empty before updating the database.

Class

TCustomDADataSet

Syntax

property KeyFields: string;

Remarks

TCustomDADataset uses the KeyFields property to build SQL statements for the SQLDelete, SQLInsert, and SQLUpdate properties if they were empty before updating the database. For this feature KeyFields may hold a list of semicolon-delimited field names. If KeyFields is not defined before opening a dataset, TCustomDADataset requests metadata from a server, database or dataset depending on the provider.

Note: For InterBase provider, though keys may be created across a number of table fields, sequence is generated only for the first field found in the KeyFields property.

See Also

• SQLDelete
• SQLInsert
• SQLRefresh
• SQLUpdate