>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
>SQLEXEC(_Screen.sqlconn,'commit tran')
>
Not sure if this could help, but check message #
1361095
If it's not broken, fix it until it is.
My Blog