Updated: 2023-11-07

Data Source Initialization OLE DB Property — «auto_update_field_rule»

Name:
auto_update_field_rule
Type:
VT_I2
R/W:
R/W
Default:
EMPTY
IBProvider:
2, 3, 5

Rule of the generation SQL-query for the update of a row of database table.

Value Description
0 Provider enumerates all the columns. DEFAULT values are processed as NULL values.
1 Provider enumerates only modified columns. DEFAULT values are processed as NULL values.
2 Provider enumerates all the columns. DEFAULT values are processed correctly. This mode is implemented in IBProvider v5.34 and requires the support of server (FB4+).
3 Provider enumerates only modified columns. DEFAULT values are processed correctly. This mode is implemented in IBProvider v5.34 and requires the support of server (FB4+).

The minimization of net traffic is ensured values 1 and 3.

If you do not specify the value of this property, then the provider will choose the appropriate mode, taking into account the capabilities of the database server:

Value Conditional
2 Firebird 4+.
0 In all other cases.

See also

Other properties of group

Other sets of properties