Re: Row level locking when using ADO Query

Dimitar,

Short answer is you cannot. There is no way to modify the underlying SQL
generated by the ADO provider.
Long answer is you can if you use TClientDataSets (writing your own script
in the corresponding TDataSetProviders BeforeUpdateRecord event)
http://community.borland.com/article/0,1410,22571,00.html

Good luck,
krf

"Dimitar Antonov" <dantonov@xxxxxxxxxx> wrote in message
news:42b9844d@xxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> can enybody write me,
> how can I use a Row level lock like
> "INSERT INTO TableNeme WITH (ROWLOCK) ...."
> OR
> "UPDATE TableNeme WITH (ROWLOCK) SET ..."
>
> when I use a TADOQuery method Post:
>
> ADOQuery.Post
>
> Please help!
>
> Best regards
> Dimitar Antonov
>
>


.