Hi all
i am trying to skip a record from my list if another user is in use in sql server 2005
Example

in my table 2 records

Id Name
1 Sac First user using this
2 Mac

and now second user also want to edit. at that time i want to skip 1st record from edit list. so please tell me how it is possible.

Just i try to use rowlock and readpast in sql statement but it could not work

SQLEXEC(_Screen.sqlconn,'begin tran')
SQLEXEC(_screen.sqlconn,'select * from mst015 with(updlock) where id=1')
brow
SQLEXEC(_screen.sqlconn,'select * from mst015 with(readpast)')
brow     && here i want to skip id=1
SQLEXEC(_Screen.sqlconn,'commit tran')