|
TOraDataSet.KeyFields Property |
|
|
|
TOraDataSet.KeyFields Property |
|
Used to build SQL statements for the SQLDelete, SQLInsert, and SQLUpdate properties if they were empty before updating a database.
property KeyFields: string;
Assign the KeyFields property to build SQL statements for the SQLDelete, SQLInsert, and SQLUpdate properties if they were empty before updating a database. To exploit this feature KeyFields may hold a list of semicolon-delimited field names. If KeyFields was not defined before opening the dataset, ROWID pseudo fields are used.
Besides, the KeyFields property may hold the name of a field which will be later assigned with Oracle sequenced values. Beforehand Oracle sequence must be created and its name passed to the KeySequence property.
Sequences are generated when either TDataSet.Insert or TDataSet.Post method is called. Which of these two methods is used to modify the database is determined by the SequenceMode property.
Note: Although keys may be created across a number of table fields, sequence is generated only for the first field found in the KeyFields property.