SQLData object data transfer commands

If one of the Boolean command attributes (attributes with the suffix "Cmd") is set to TRUE, the SQLData object transfers values to and from the SQL Server database table to the assigned attributes or temporary attributes. The temporary attributes are dynamic runtime attributes that are automatically created for each column in the database table. The temporary attribute values can be transferred to and from the database table, as well as to and from the assigned attributes.

During runtime, the DBToAttrCmd and DBToTempCmd command attributes select a record in the database before the database values are transferred. The selecting of a record uses a SQL Server query. For more information, see SQLData object runtime query string. If the query does not return one record (that is, either no record or multiple records), an error is generated and no data is transferred.

Each time database and temporary values are transferred to the assigned attributes, a Boolean flag is set to TRUE to indicate a successful data transfer. The flag is reset (set to FALSE) by a reset command, or by subsequent transfer to command attributes.