MSSQL TABLOCKX ?
- From: "Olivier Matrot" <olivier.matrot.rte@xxxxxxxxxxxxx>
- Date: Mon, 22 May 2006 14:21:23 +0200
Hello all,
Using only OLE DB IRowsetChange Interface, I would like to populate a rowset
from a table, while maintaining an exclusive lock on it, then update records
and release the lock.
From now on, my Rowset is pospulated with an SQL QUERY that does the job,using the WITH TABLOCKX statement. But I do want my code to be DBMS
agnostic.
TIA.
.
- Follow-Ups:
- Re: MSSQL TABLOCKX ?
- From: Erland Sommarskog
- Re: MSSQL TABLOCKX ?
- Prev by Date: Re: VFPOLEDB, SQL2000, linked server, memo field
- Next by Date: Re: MSSQL TABLOCKX ?
- Previous by thread: Re: Getting column types with oledb
- Next by thread: Re: MSSQL TABLOCKX ?
- Index(es):