Lock question / t-sql

From: Perry van Kuppeveld (REMOVEperry_at_REMOVEwinit.nl)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 11:25:59 +0200

Hi,

What's ado's equivalent (Connection.IsolationLevel, Recordset.Cursortype,
Recordset.Locktype etc.) to the following query:

select x from y with (xlock, readpast, readcommitted)

Thanks

Perry

Relevant Pages

  • Re: Need Running Balance
    ... "Perry" wrote in message ... >> I have copied and pasted the above code into an empty query, ... > In query design, try to play around with the aggregation/group by query. ...
    (microsoft.public.access.forms)
  • Re: Why Select Count(1) = Group by
    ... "Patrick Paquette" wrote in message ... > Because i have a lot of huge query and i think that the group by will be ... FROM TB_C_Cmd c WITH (READPAST) ... LEFT OUTER JOIN TB_L_LegInfo li WITH ON li.LegInfo_ID = ...
    (microsoft.public.sqlserver.programming)
  • Delete
    ... Let me give you the exact question...Using a query, delete all records in the Product table where the description starts with the letter R.. ... I am a beginner so be specific if you can Thanks Perry or anyone else that cares to help out ...
    (microsoft.public.access.queries)