MS SQL 2000, ADO and edit lock

I am using ADO to access MS SQL 2000 db in Delphi 5 app.

Lets say i have the following TADODataSet

SELECT * FROM MYTABLE WHERE ID = :MYID

I want to edit the record and then Post.

Is there a way i can ask MS SQL if given row is already "selected for edit"
by another user?

Does ADO places any locks during the SELECT?

Thanks,
Eugene.


.

Relevant Pages

  • Re: Using parameters with the low level ADO API, trying to avoid the memory leaks.
    ... MS ADO passes SQL directly to OLEDB provider. ...
    (borland.public.delphi.database.ado)
  • Re: Programmatically changing a SQL view in a ADP
    ... One of the differences between DAO and ADO is that DAO combines data ... there isn't a way to do this successfully with ADOX. ... But T-SQL, SQL Server's ... Dim cn As ADODB.Connection ...
    (microsoft.public.access.modulesdaovba)
  • Re: Smartest way toa add records manually
    ... class modules to represent tables, collections, etc., and started isolating ... we've transitioned from Access as a back end to SQL Server as ... Then I discovered why I transitioned to ADO. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Prevent Commands in SQL Update
    ... I am not familiar with PHP, but ADO is ADO ... ... sinple way to clean an SQL statement. ... Server-side validation of ALL user input MUST be done, ...
    (microsoft.public.data.ado)
  • Re: dumb previous question - repost
    ... dataaccess technology not a datatransfer technology although it can be used ... Here is what I do right now with com ado from ... > With my com ado loop above I can transfer 5000 records ... > from sql server to Access in a few seconds. ...
    (microsoft.public.dotnet.framework.adonet)