| Subject | Re: [firebird-support] cannot update erased record |
|---|---|
| Author | Helen Borrie |
| Post date | 2006-01-23T03:17:28Z |
At 01:34 PM 23/01/2006, you wrote:
exception and interpreting it as this condition...for it's not a
Firebird error message.
What it might be is a handler responding to a custom exception in a
delete trigger...or, more likely, handling the result of some other
request that had requested an update in a WAIT transaction, waiting
for your multi-row delete to finish...only to be told finally that
the record it was waiting for had been deleted.
./heLen
>I am getting the error cannot update erased record occasionly whenI guess it means that your exception handler code is picking up some
>running this query on firebird 1.5:
>
>"delete from vorder where vosession=? or
>((vodatetime+1)<current_timestamp)"
>
>The table vorder has a few thousand recodrs in it at any one time.
>
>Does anybody know what this error means?
exception and interpreting it as this condition...for it's not a
Firebird error message.
What it might be is a handler responding to a custom exception in a
delete trigger...or, more likely, handling the result of some other
request that had requested an update in a WAIT transaction, waiting
for your multi-row delete to finish...only to be told finally that
the record it was waiting for had been deleted.
./heLen