Board index » delphi » Lock table from SQL SERVER 7.0

Lock table from SQL SERVER 7.0

Hi !

   I have a transaction of execution throughout , the users cannot data
update relation.

Property CacheUpdate is true

Work with Delphi 5 x SQL SERVER 7

Thank You !

 

Re:Lock table from SQL SERVER 7.0


This is in SQL Server

begin tran
select * from tablename holdlock
-- any process like
    update tablename set field=value
commit tran

Quote
marcelo lima <mml...@pcrj.rj.gov.br> wrote in message

news:39d38ba8_1@dnews...
Quote
> Hi !

>    I have a transaction of execution throughout , the users cannot data
> update relation.

> Property CacheUpdate is true

> Work with Delphi 5 x SQL SERVER 7

> Thank You !

Other Threads