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

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

Other properties of group

Other sets of properties