SQL Select question

Hello,

The following select statement will select all rows from myTable for UPDATE and all other users will be blocked until I close the select statement.

Select * from myTable FOR UPDATE WHERE rowstate = 'Posted'

Now if any new rows are added with rowstate of 'Posted' no other users will be able to select them for update. Does anybody know how to get around this?

I essentally want the user to be able to lock a set of rows do some processing then update them, change rowstate to 'Processed' or is there anyway I can detect which rows are locked?

Thanks,
Rob Panosh Received on Mon Dec 23 2002 - 16:08:11 CET