YiZeng
May 13th, 1999, 09:12 AM
I am designing a project which will use some important features such as transaction,various locks provided by Microsoft SQL Server 7.0. I am not sure if ODBC 3.0 can achieve this goal.
Can I execute full set of Transact-SQL through pDataBase->ExcuteSQL(...)?
Are following codes valid(Perform transaction using Transact-SQL)?
pDataBase->ExecuteSQL("BEGIN TRANSACTION");
pRecordSet->OPEN(...,"Select * from Table1 with (updlock)",...);
...
pDataBase->ExecuteSQL("COMMIT TRANSACTION");
If I cannot achieve this goal,I have only to use DB-Library for C.
Thank you for your kindly help!!!
YiZeng
Can I execute full set of Transact-SQL through pDataBase->ExcuteSQL(...)?
Are following codes valid(Perform transaction using Transact-SQL)?
pDataBase->ExecuteSQL("BEGIN TRANSACTION");
pRecordSet->OPEN(...,"Select * from Table1 with (updlock)",...);
...
pDataBase->ExecuteSQL("COMMIT TRANSACTION");
If I cannot achieve this goal,I have only to use DB-Library for C.
Thank you for your kindly help!!!
YiZeng