Re: MS SQL 2000, ADO and edit lock

From: "Del Murray" <Del.Murray@xxxxxxxxxxxxxx>
Date: Mon, 3 Dec 2007 08:25:01 -0600

BTW .. i think you want to not use "pessemistic" locking in the object and
specify the "lock hint" in the sql statement itself in order to get row
locking, otherwise you will get a lock to occur only when you start to
change the data, not when you read it.

.

Follow-Ups:
- Re: MS SQL 2000, ADO and edit lock
  - From: Eugene V. Goldberg

References:
- MS SQL 2000, ADO and edit lock
  - From: Eugene V. Goldberg
- Re: MS SQL 2000, ADO and edit lock
  - From: Del Murray
- Re: MS SQL 2000, ADO and edit lock
  - From: Eugene V. Goldberg

Prev by Date: SQL Strings kleine Unterschiede --grosse Wirkung ??
Next by Date: sorry once more in english: sql : little differences big effects ??
Previous by thread: Re: MS SQL 2000, ADO and edit lock
Next by thread: Re: MS SQL 2000, ADO and edit lock
Index(es):
- Date
- Thread

Relevant Pages

Re: dbSeeChanges
... I'm not sure where to insert the 'Debug' script without it locking up ... but I don't think the problem is with the SQL statement without it ... task with Task Manager. ... Set lrs = dbs.OpenRecordset ...
(comp.databases.ms-access)
Re: sky on freeview tv
... various types available on the market with screened/non-screen and locking mechanisms. ... Unfortunately the DTG report does not specify any standard design for the locking mechanism, and its retention test specification is rather weak, as thicker cables tend to need high retention force. ... I have a similar scart setup but I've never any problems with leads,. ...
(uk.tech.digital-tv)
Re: dbSeeChanges
... I'm not sure where to insert the 'Debug' script without it locking up ... but I don't think the problem is with the SQL statement without it ... By creating the query, you can mess around with it and see if the query works. ... Set lrs = dbs.OpenRecordset ...
(comp.databases.ms-access)