Subject Re: [firebird-support] FB 2.5 and SQL Message : -607,This operation is not defined for system tables.
Author Mark Rotteveel
On 3-1-2014 15:32, Luigi Siciliano wrote:
> Hallo,
> The subsequent SQL Code is accepted in FB 2.1 but not in FB 2.5:
> -----------------------------------------------------------------------------
> SET TERM ^ ;
>
> CREATE OR ALTER TRIGGER AA_CEDOLINI FOR CEDOLINI
> ACTIVE AFTER INSERT OR UPDATE OR DELETE POSITION 0
> AS
> BEGIN
> /* è */
> END^
> SET TERM ; ^
> -----------------------------------------------------------------------------
>
> if I substitute the accented vowel "è" with "e'" the code is accepted
> and executed!
>
> In a select statement the accented vowel is accepted, seems that the
> problems is on triggers or stored procedures.
>
> Is this a bug? or I have a mistake?

Works fine for me using FlameRobin on FB 2.5.2 Update 1, connection
character set UTF-8. What is your connection character set, and how are
you executing this?

Mark
--
Mark Rotteveel