Hello all,

I am newbie with Pervasive.
Using Pervasive SQL V8

When I try to create this simple trigger
CREATE TRIGGER TR_UPDT_A
AFTER INSERT ON tblA FOR EACH ROW
UPDATE tblB SET tblB.NbrToPrint=tblB.NbrToPrint + 1 WHERE tblB.IdB=NEW.fiB;
I receive this error:
ODBC Error: SQLSTATE = S1000, Native error code = -5099
3: '<EOF>': Syntax error

I Probably do something wrong, but what ?

Thanks for any help
Guy

Try adding a BEGIN/END Block around it:
CREATE TRIGGER TR_UPDT_A
AFTER INSERT ON tblA FOR EACH ROW
BEGIN
UPDATE tblB
SET tblB.NbrToPrint = tblB.NbrToPrint + 1
WHERE tblB.IdB = NEW.fiB;
END

Might work better...
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: June, 2004: See our web site for details!


Guy wrote: