Subject Re: [firebird-support] best way of selecting some records of a table
Author Sergio H. Gonzalez
From: "Fulvio Senore"
> What about storing the IDs in memory instead of writing them to a
> temporary table?

Hi Fulvio, thanks for the reply, but I'd like the DB to "know" what the selected
fields are. Because I'm looking for a general solution and in some cases I use
the selected fields in a stored procedure. And sometimes a selected record
implies that other users can't select it until the first user commit or
rollback. That would be the case for selected invoices when I'm doing a payment.
The second user can't select the same invoice unless the first user cancel the
operation (the payment)

-sergio