Delphi Database, Delphi Components from ComponentAce
Products Download Order Contact us
TDataSet.SetFields
TDataSet
Top 


Sets the values for all fields in a record

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 may 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.

Note:   To set values for some fields while retaining existing values for others, pass nil for each field that should not change.
        © 2003 - 2024 ComponentAce  | .net zip component | barcode for .net | delphi zip component | delphi database Apr 18, 2024