Subject | FB 2.5 and SQL Message : -607,This operation is not defined for system tables. |
---|---|
Author | Luigi Siciliano |
Post date | 2014-01-03T14:32:11Z |
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?
Thanks.
--
Luigi Siciliano
--------------------------
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?
Thanks.
--
Luigi Siciliano
--------------------------