Re: INSERTED 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" <golds...@xxxxxxxxxxxxx> 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...@xxxxxxxxxxxxxxxxxxxx
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 -


.

Relevant Pages

  • Re: :NEW Values in trigger doesnt seem to work
    ... rgrubin@xxxxxxxxx schreef: ... CREATE OR REPLACE TRIGGER NIKU.FCG_UPDTASK4PROC_T1 ... REFERENCING NEW AS New OLD AS Old ... SET testfield = '7' ...
    (comp.databases.oracle.misc)
  • Re: INSERTED in PSQL
    ... interface to access the data -- you cannot use Native Btrieve. ... there are no special tables for trigger ... Search the online manuals for REFERENCING, ...
    (comp.databases.btrieve)
  • Re: SQL trigger oddity
    ... That's what the SQL standards committee came up with. ... alias refers to must also exist when the trigger is created. ... I can see that the CREATE TRIGGER statement might fail if the *program* ... referencing old as old_line new as new_line ...
    (comp.sys.ibm.as400.misc)
  • Re: INSERT TRIGGER
    ... Is it possible to insert more than one SQL-Query in the Action-Part of the Trigger? ... REFERENCING OLD AS pre NEW AS post ... (insert into tab2 values (1,"From Trigger")); ... insert into tab1 values; ...
    (comp.databases.informix)
  • Re: ora-1410 on a delete trigger
    ... CREATE OR REPLACE TRIGGER t_tbl1 ... after delete on tbl1 ... referencing old AS oldRow ...
    (comp.databases.oracle.server)