|
|
|
The <fields> definition lists the field names and values for the object.
FIELDS
<field> = <value>;
END_FIELDS
The <field> value is a field on the object. Any number of fields can be listed within the FIELDS/END_FIELDS pair, but not all of the object's fields must be listed.
The <value> is either the value to assign to the field for an insert or update, or the value currently assigned to the field if it's a unique key. The <value> form must match the underlying data type of the field, because values are stored in the database exactly as entered. For example, integer database fields require an integer format.
When used with the OBJECT element, the object's fields are either inserted or updated. If one or more of the object's fields are not defined for an insert, the unlisted field(s) will be assigned a default value. If one or more of the object's fields are not defined for an update, the existing value(s) will be unchanged.
When used with the REFERENCE or DELETE element, any extra fields listed that are not part of the <uniques> list will be ignored.
This section describes how to construct common values used in the <fields> definition.
See Also |
Next |