Hi,

We are using Pervasive 7, Win2000 Server

I need to create a trigger that will call a procedure everytime a
record has been update.

I have the procedure sql but i have problems with the trigger

CREATE PROCEDURE QtyShpd (in :SONU CHAR(100))
AS BEGIN
UPDATE BKARINVL SET BKA_QTYSHIP = BKA_QTYORD WHERE BKA_SONUM = :SONUM;
END;

Can a trigger be "run" everything a record is updated it?
Can the same trigger pass a value to the procedure??

Thank you All

Bre-x,

Triggers in Pervasive.SQL "break" the Btrieve-level access. Do NOT use
Triggers if you have any Btrieve-level applications.

Having said that, triggers DO work, although your Pervasive.SQL 7 server
engine should be patched first to Service Pack 5, and then to SP6 for the
best results. See the manual for the exact syntax documentation.
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: November 16-19, 2004: See our web site for details!


Bre-x wrote: