Sets the values for all fields in a record.
Syntax:
procedure SetFields(const Values: array of const);
Description:
Call SetFields to set values for some or all fields in the active record at the same time.
Values contains the values to insert into each field. Values are assigned to the record based on the order of columns in the table or tables underlying the dataset. These values can be literals, variables, NULL, or nil. If Values contains fewer values than there are fields in the record, all records for which values are not provided are assigned a NULL value. A NULL value overwrites any existing value in such fields.
Before calling SetFields, call Edit to put the dataset into dsEdit state. After calling SetFields, call Post to write the changes to the database.
To set values for some fields while retaining existing values for others, pass nil for each field that should not change.