Subject | Expression evaluation not supported |
---|---|
Author | Ed Dressel |
Post date | 2003-10-27T17:49:15Z |
In the folloing attempt to create a trigger:
SET TERM ^;
CREATE TRIGGER TRIG_SOMETABLE_BU FOR SOMETABLE BEFORE UPDATE
AS
declare variable Notation varchar(100);
BEGIN
Notation = '';
if (OLD.FIELDNAME <> NEW.FIELDNAME) then
Notation = 'Changed name from "' + Old.FIELDNAME + '" to "'
+ New.FIELDNAME + '"';
END ^
...
I get an error:
Expression evaluation not supported.
If I remove the concantiantion of strings then it seems to work fine.
What am I doing wrong?
Thanks
Ed Dressel
SET TERM ^;
CREATE TRIGGER TRIG_SOMETABLE_BU FOR SOMETABLE BEFORE UPDATE
AS
declare variable Notation varchar(100);
BEGIN
Notation = '';
if (OLD.FIELDNAME <> NEW.FIELDNAME) then
Notation = 'Changed name from "' + Old.FIELDNAME + '" to "'
+ New.FIELDNAME + '"';
END ^
...
I get an error:
Expression evaluation not supported.
If I remove the concantiantion of strings then it seems to work fine.
What am I doing wrong?
Thanks
Ed Dressel