General discussion

Locked

How to lock a record

By cheung_herman ·
Hello guys,

My problem is How to lock a record when the user updating a record, so the other user cannot open the same record while it still being updating, and now I'm using ASP for my programming language, Ms. Access or SQL Server as the database and use ADO method to Insert, update, delete or select a record.

Beside there How to disabled the F5 (function)button in IE (Internet Explorer) ?

Thank's for the time to read my problem?? Sorry.. my english is not very well And I hope some body can solve it.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

How to lock a record

by ghousem In reply to How to lock a record

Here is the SQL for ROWLOCK.

UPDATE employee
SET salary = 10000
FROM employee
WITH (ROWLOCK)
WHERE start_date < '1/1/2002'

Ghouse Mohiuddin

Collapse -

How to lock a record

by cheung_herman In reply to How to lock a record

Poster rated this answer

Collapse -

How to lock a record

by ChennaiTechie In reply to How to lock a record

Actually you need not manually locka record in a database when you are accessing the way you are currently doing.it is done automatically.

And to your second question, my answer would be "U Cannot do that"

Collapse -

How to lock a record

by cheung_herman In reply to How to lock a record

thank's for comment but I still don't understand what do you mean "IT IS DONE AUTOMATICALLY" ??? and my second question it will answered by Microsoft but I don't know the Microsoft e-mail address for this question.

Collapse -

How to lock a record

by cheung_herman In reply to How to lock a record

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Software Forums