concurrency options in SDAC?
Posted: Wed 23 May 2007 08:07
Using ADO, I can set currency options using LockType property of Recordset object, in ODBC I have stament attribute SQL_ATTR_CONCURRENCY. How can I do this using sdac? thx.
[/code]ADO applications
Specify adLockReadOnly, adLockPessimistic, adLockOptimistic, or adLockBatchOptimistic in the LockType property of a Recordset object.
ODBC applications
Set the statement attribute SQL_ATTR_CONCURRENCY to SQL_CONCUR_READ_ONLY, SQL_CONCUR_ROWVER, SQL_CONCUR_VALUES, or SQL_CONCUR_LOCK.