Lock record Delphi 7 / SQL2000

2004-08-06 12:52:05 AM
I want to lock record in my application when my ADOQuery.state is in dsEdit
I tried all the combinaison of LockType, CursorType, CursorLocation and
ConnectMode, but i don 't succeed.
My SQL statement is simple : select * from country
I launch my App twice. I modify a data on my first screen, i can modify the
same data with the second screen of my app !!!
How can i do to lock the record the first user modify, and prevent the
second user the data is not enabled ?
Thanks for your help