Updated: 2018-05-07

Data Source Initialization OLE DB Property – «server_data_back_read»

Name:
server_data_back_read
Type:
VT_I4
R/W:
R/W
Default:
0
IBProvider:
3.50

Setting up rules for rereading the changes of the updatable set. A zero value or the union of the following flags is allowed:

Значение Описание
1 Re-read columns of inserted row. Server should support the queries like «INSERT INTO … RETURNING …».
2 Re-read columns of updated row. Server should support the queries like «UPDATE … RETURNING …».

Example for VBScript and ADODB

option explicit

dim cn,rs,v,f

set cn=createobject("ADODB.Connection")

cn.ConnectionString= _
 "provider=LCPI.IBProvider.3;"& _
 "location=inet4://localhost/d:\database\fb_03_0_0\employee.fdb;"& _
 "user id=SYSDBA;"& _
 "password=masterkey;"& _
 "dbclient_type=fb.direct;"& _
 "server_data_back_read=3"

call cn.Open()

call cn.BeginTrans()

set rs=createobject("ADODB.Recordset")

'LockType =adLockPessimistic (2)
call rs.Open("EMPLOYEE",cn,,2)

f=array("FIRST_NAME","LAST_NAME","DEPT_NO",_
        "JOB_CODE","JOB_GRADE","JOB_COUNTRY", _
        "SALARY")

v=array("Agent","Smit","000", _
        "Admin","4","USA", _
        40000)

call rs.AddNew(f,v)

wscript.echo "EMP_NO    : "&rs("EMP_NO").value
wscript.echo "HIRE_DATE : "&rs("HIRE_DATE").value

call cn.RollbackTrans()

Output:

Sample 001. Output.

See also

Other properties of group

Other sets of properties