Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error while creating a trigger

Status
Not open for further replies.

domn

Programmer
Oct 6, 2003
1
AL
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top