Hello @ll,

I have found the problem. I don't know how and why, but in the odbc-driver
was set the "No wait on locks"-checkbox. After I have removed the checkbox,
it works fine.

This was also the problem from yesterday with my triggers.

Thank you, I hope I can help some other user with the same mistake.


Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Im Auftrag von Olaf Kluge
Gesendet: Montag, 20. Juli 2009 16:54
An: firebird-support@yahoogroups.com
Betreff: [firebird-support]




Hello,

I have already a big problem. Thanks for your helping hand.

If I change a value direct in my IB-Manager, the trigger of one table (after
update) works fine. If I change the value over odbc (microsoft access), the
value is changed, but the trigger doesn't works. I mean, if I change a value
to null, the trigger works not over odbc, but only in one table not. If I
change the value to another number, it works very well. Both inputs I have
made in the linked table direct.

If I change the value to null in my IB-Manager, the trigger works very well.

The problem was never with the version 2.0 of firebird. Now I have version
2.1.1.

Is this a bug? Should I update my firebird-installation=

Thank you very much for your fast answer.

Olaf Kluge






No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.392 / Virus Database: 270.13.20/2250 - Release Date: 07/20/09
06:16:00