MS SQL has Inserted and Deleted tables that I used in my triggers. Is
there Inserted/Deleted tables in PSQL?

If you are using Triggers, please be aware that you MUST use the SQL
interface to access the data -- you cannot use Native Btrieve.

Having made that disclaimer, there are no special tables for trigger
data, although each trigger should fire for each inserted/deleted
record, and you can use the "REFERENCING" clause to access the inserted
or deleted data.

Search the online manuals for REFERENCING, or look under the TRIGGER
syntax section, for more information.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 03/2007 ***


Rookie wrote:

Thanks Bill.

I was hoping to write a trigger using Pervasive.SQL Control Center.

REFERNCING should help.

Thanks again.
************************************************** ***************************

On Mar 14, 7:22 am, "Bill Bach" <golds... (AT) speakeasy (DOT) net> wrote: