|Subject||Re: [firebird-support] Dynamic SQL Error: need help understanding|
> I can't find the error message shown below, in any documentation. I've searched the web, and still no help. Using Firebird 18.104.22.16885, manage with IBExpert.If this trigger is generated by LogManager of IBExpert (at least it
> Error Message:
> Invalid token.
> Dynamic SQL Error.
> SQL error code = @1.
> Token unknown - line @1, column @2.
> My code snippet below. I think the problem is with the last line I included. At least it is the one highlighted by IBExpert.
> create or alter trigger IBE$DETA_AU for DETA
> active after update position 32767
> declare variable TID integer;
> declare variable VUSER varchar(3);
> declare variable VPOS integer;
> TID = gen_id(IBE$LOG_TABLES_GEN, 1);
> VUSER = new.USER_FOR_LOGGING;
> VPOS = position('@', :VUSER);
> if (:VPOS<> 0) then VUSER = substring(VUSER from 1 to (:VPOS - 1));
looks like), then you should consider telling the IBE guys to fix that
or you could simply try our IB LogManager product, which is specialized
for logging/auditing tasks.
Sorry, could not resist. ;-)
Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server