Updated: 2023-11-07
OLE DB Property of Rowset and Command — «auto_insert_field_rule»
Name:
auto_insert_field_rule
Type:
VT_I2
R/W:
R/W
Default:
It derives initialization property auto_insert_field_rule
IBProvider:
2, 3, 5
Rule for generation of SQL query (INSERT INTO…) for insert a new row into updatable result set. Allowed values:
| Value | Description |
| 0 | Provider enumerates all the columns. Non-initialized columns are passed as NULL. |
| 1 | Provider enumerates only columns with NOT DEFAULT values. The provider may return error if there is no at least one initialized column. |
| 2 | Provider enumerates only OK-columns (those do not have DEFAULT or NULL values). The provider may return error, if all columns of new row are NULL or have DEFAULT values. |
Focus attention that if table, in which new row is inserted, contains columns with DEFAULT values then you should set the property in 1.
The minimization of net traffic is ensured by values 1 and 2 of the property.
If the value of this property is EMPTY, then the provider will choose the appropriate mode, taking into account the capabilities of the database server.
| Value | Conditional |
| 1 | Firebird 2.5+. If there are no initialized columns, the provider will generate a request «INSERT INTO … DEFAULT VALUES». |
| 0 | In all other cases. |
See also
- The rowset property insert_sql
- The rowset property auto_update_field_rule
- The rowset property auto_gen_key_rule
- The initialization property auto_insert_field_rule