record lock

[Saturn57]

I have a recordlock field in a table and I would like to know if there is a feature in sql that will allow me to take advantage of this field to lock the record from being altered in any attached applications.

 

[jbenson001]

No. You will have to handle that on the front end by not allowing the user to edit th record or not show the record at all.

 

[markros]

This is suggested in another forum:

-- Will hold a lock on a record until COMMIT is issued. Exec 1 line at a time in SMSS


BEGIN TRANSACTION

SELECT SomeColumn FROM dbo.MyTable WITH (TABLOCKX) WHERE SomeCriteria

(Now run application code against locked record)

COMMIT -- Releases lock

 

[danvlas]

Write an 'Instead of Update trigger' on the table.


Daniel Vlas
Systems Consultant

 

[Saturn57]

How do you write an instead of update trigger?

 

[jbenson001]

Look in Books On Line

 

[danvlas]

The following link will explain best (I think it was George - gmmastros - who posted it first):

How do you write an instead of update trigger

HTH


Daniel Vlas
Systems Consultant