Hi.
I'm using SQLBase 7.5.1. I try to create a trigger by issuing:
CREATE TRIGGER TRIG1 after insert on EMP
(EXECUTE inline (EMP.rowid)
PROCEDURE P41 static
string: RowIdentifier
Action
call SqlImmediate('update EMP set (c1 = c1 + 5 where EMP.rowid =:RowIdentifier'))
for each row;
this example is given in Centura Books Online.
But this causes an error:
..............
..............
for each row
^
Error: Procedure section (name) expected
Can anyone help me where is the syntax error?
Thank you in advance.
I'm using SQLBase 7.5.1. I try to create a trigger by issuing:
CREATE TRIGGER TRIG1 after insert on EMP
(EXECUTE inline (EMP.rowid)
PROCEDURE P41 static
string: RowIdentifier
Action
call SqlImmediate('update EMP set (c1 = c1 + 5 where EMP.rowid =:RowIdentifier'))
for each row;
this example is given in Centura Books Online.
But this causes an error:
..............
..............
for each row
^
Error: Procedure section (name) expected
Can anyone help me where is the syntax error?
Thank you in advance.