Subject Expression evaluation not supported
Author Ed Dressel
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