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, 5

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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
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