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
- The initialization property auto_insert_field_rule
- The rowset property auto_update_field_rule
- The rowset property update_sql