| Subject | Re: [ib-support] Firebird 1.5 - SELECT FOR UPDATE |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-04-26T02:30:49Z |
At 01:32 AM 26/04/2003 +0000, you wrote:
A pessimistic lock won't prevent other transactions from *viewing* the
locked records. It is intended to deny any other transaction from updating
or deleting them.
Do you understand that this is not for normal use? It runs contrary to the
architecture of Firebird and potentially locks up huge numbers of
records. It is for use only in the very particular circumstance where you
need updates to be truly serial - a very rare requirement. Avoid it,
except where there is an absolute requirement for serial updates.
heLen
>Im trying to useTell us what you *expect* it to do.
>
>SELECT * FROM TABLE
>WHERE FIELD = 'SOMETHING'
>FOR UPDATE WITH LOCK
>
>in fb 1.5 rc1
>
>in delphi 7, with dbexpress...
>but it always returns the records,
A pessimistic lock won't prevent other transactions from *viewing* the
locked records. It is intended to deny any other transaction from updating
or deleting them.
>is it working?Describe what you *want* to do.
>someone knows what I have to do?
Do you understand that this is not for normal use? It runs contrary to the
architecture of Firebird and potentially locks up huge numbers of
records. It is for use only in the very particular circumstance where you
need updates to be truly serial - a very rare requirement. Avoid it,
except where there is an absolute requirement for serial updates.
heLen