Subject | Re: [firebird-support] best way of selecting some records of a table |
---|---|
Author | Sergio H. Gonzalez |
Post date | 2008-08-12T20:51:01Z |
From: "Fulvio Senore"
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
> What about storing the IDs in memory instead of writing them to aHi Fulvio, thanks for the reply, but I'd like the DB to "know" what the selected
> temporary table?
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