To add some more information.

I made a shut down of the DB.
I made a backup and a restore.

This solved my problem.

Then to make this newly restored DB available, I had to shortly stop
the firebird service from running on this server(resulting in a lot of
lost connections on the other 8 DBs).

After this newly restored DB was available it all worked fine.

I then copied the broken DB to another server to try to see what the
error was.
Here the DB worked fine.

I then placed it back in the original server but on another place -
And funny - Now the DB worked fine.

So my conclusion must be, that firebird it self must have been doing
something, which led to this error.
And now I cant reproduce it.


The SQL that led to the error in the first place is simpel.
Its like this:

UPDATE VAREFRVSTR_DETAIL SET
ANTALSTK = ANTALSTK - :PANTALSTK,
BEH_SALGSPRIS = BEH_SALGSPRIS - :PYTD_SOLGTSALGSPRIS,
BEH_KOSTPRIS = BEH_KOSTPRIS - :PYTD_SOLGTKOSTPRIS,
BEH_SALGSPRISMOMS = BEH_SALGSPRISMOMS - :PYTD_SOLGTMOMS,
SIDSTESALGSDATO = :PSIDSTESALGSDATO
WHERE
V509INdex = :PV509INdex AND
AFDELING_ID = :PAFDELING_ID;


A trigger is fired, which is doing an update on 6 other tables (in the
same way as above).


Sinse its all working again the problem is over. But Im curriouos to
why it happen in the first place....

Michael