Hello,

> Thanks for your quick reply. Also thanks to Martijn. The maxLogID variable
> issue is fixed - as you mentioned, the "select" statement was too much.
>
> The trigger "TRU_country" is used to write information to a log table

(named

> here Shadow_country) when something changes in the country table.
> I still can not write the trigger to the db. I get now the error message
> "invalid request BLR at offset 103 undefined message number" - any idea?
>
> What do you mean by "specifying zero step"?

GEN_ID(... , 0) -> this will get the CURRENT value of the generator,
not a new unique number.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com