SELECT...FOR UPDATE under ATL OLEDB
I use ATL generated OLEDB consumer to connect to an Oracle database. I
have to support cocurrent access from multiple users. I have a Long
Raw column under my table. Oracle requires us to call SELECT...FOR
UPDATE statment to do row level locking when reading this column. I
wonder how to use it properly in my OLEDB consumer code. I use
StartTransaction() of CSession to start a transaction and then
construct the "SELECT ... FOR UPDATE" as SQL under CCommand. I get an
error saying only one transaction can be running at a time.
Has anybody tried similar thing before. What would be the correct
syntax to make SELECT...FOR UPDATE works in a similar mannar as
SELECT ... FROM theTable WITH(UPDLOCK) in SQL Server.
Thanks,
DP
Sent via Deja.com http://www.*-*-*.com/
Before you buy.
