Record locking thr ODBC

Deodatta Natekar -- dvn@surya.trddc.ernet.in
Saturday, March 08, 1997

Environment: VC++ 1.51, Win 3.1 (WG), ODBC 2.0
(back end Oracle 7.1 and SQL Server 6.5 )

Hi,
	I want to lock the records in the tables in the DB through ODBC. We are =
following optimistic locking strategy of CRecordSet. I want to update =
few rows in table A while locking some rows in base table B ( I am not =
updating table B at all. )
	In short the process is as follows.

BeginTrans
	Lock rows in table B
	update rows in Table A
		(set m_strFilter
		  open recordset.
		  edit recordset
		  change  the values.
		  Update recorset.
		  Close recordset.)
	unlock Table B
commit.

	"Update Table A" causes optimistic locking for table A. But how to =
achieve  locking for Table B ?

regards,

Deodatta Natekar=20
(dvn@surya.trddc.ernet.in )

---

Fernando Pereira -- morgan@cardume.com
Tuesday, March 11, 1997

The best way could be to have a CRecordset on table B with a SELECT ....
FOR UPDATE OF ... ; this will enable you just to lock the rows you desire
in B. You can create a normal CRecordset and then add this syntax to the
SQL builder or you can add it to the m_strFilter .

Fernando
CardumeSoftware

----------
From: Deodatta Natekar 
To: 'mfc-l@netcom.com'
Subject: Record locking thr ODBC
Date: Saturday, March 08, 1997 1:36 PM

Environment: VC++ 1.51, Win 3.1 (WG), ODBC 2.0
(back end Oracle 7.1 and SQL Server 6.5 )

Hi,
	I want to lock the records in the tables in the DB through ODBC. We are
following optimistic locking strategy of CRecordSet. I want to update few
rows in table A while locking some rows in base table B ( I am not updating
table B at all. )
	In short the process is as follows.

BeginTrans
	Lock rows in table B
	update rows in Table A
		(set m_strFilter
		  open recordset.
		  edit recordset
		  change  the values.
		  Update recorset.
		  Close recordset.)
	unlock Table B
commit.

	"Update Table A" causes optimistic locking for table A. But how to achieve
 locking for Table B ?

regards,

Deodatta Natekar 
(dvn@surya.trddc.ernet.in )
----------

---

Become an MFC-L member | Вернуться в корень Архива |