Hi

I found out why I can not insert the trigger into the database - it is the
point where it states "values (:maxLogID,". The question is why can I not
insert the value from maxLogID into the column "common_id" but if I type in
"2" instead of :maxLogID then it works?

Excerpt from my trigger:
insert into Shadow_country (common_id, operationType, status, CID, CNAME,
old_CID, server_name) values (:maxLogID, 'U', 'B', old.CID, old.CNAME,
old.CID, 'server2_3001');

Any Idea?

Regards
Daniel Putra

----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, February 25, 2005 2:06 PM
Subject: Re: [firebird-support] Strange errors while creating a trigger


|
| 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
|
|
|
|
| Yahoo! Groups Links
|
|
|
|
|
|