INSERTED 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@goldstarsoftware.com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 03/2007 ***


Rookie wrote:

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

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" wrote:
> 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
> BillB...@goldstarsoftware.com
> http://www.goldstarsoftware.com
> *** Chicago: Pervasive Service & Support Class - 03/2007 ***
>
>
>
> Rookie wrote:
> > MS SQL has Inserted and Deleted tables that I used in my triggers. Is
> > there Inserted/Deleted tables in PSQL?- Hide quoted text -
>
> - Show quoted text -