Re: Select Rows

Bernd Renzing wrote:
> =

> HI !
> =

> Is there an option which SELECT only Rows, which are 100% commited, and=

> where an Rowlock or something like this isnīt avaible ?
> =

> I need an FIFO Stack, and so itīs possible, that one client put some =
Rows
> in the Table, and another client wanted to fetch these Rows, but the se=
cond
> client got an Rowlock.
> =

> Did Iīve a chance to avoid this ?
> =

> Bernd.

If I understand what you are asking correctly, there really isn't a problem. The locking has to do with being able to update the records not read them. If you do a select you will get the rows as they exist at that=

moment. Received on Mon Feb 21 2000 - 11:47:10 CST