Updated: 2018-05-06
OLE DB Property of Rowset and Command — «Server Data on Insert»
Name:
Server Data on Insert
Type:
VT_BOOL
R/W:
Run Time
Default:
Run Time
IBProvider:
2, 3, 5
This is standard OLE DB setting for re-reading a data of new row after insert in database.
Complete support avaliabled beginning from IBProvider v3.50.
If the database server does not support queries like «INSERT INTO … RETURNING …», this property is defined as Read-Only and has the value False.
If the database server supports queries like «INSERT INTO … RETURNING …» (FB2.0+), this property is defined as Read-Write. The default value depends on the server_data_back_read initialization property.
In any case, you can re-read the data by specifying in the insert_sql rowset property the ODBC-call of a stored procedure with OUT-parameters.
See also
- The rowset property insert_sql
- The initialization property server_data_back_read