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;" & _ "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:
See also
- The initialization property auto_insert_field_rule
- The initialization property auto_update_field_rule
- The rowset property auto_insert_field_rule
- The rowset property auto_update_field_rule
- The rowset property Server Data on Insert