Re: triggers within commit cycles

[barsa@xxxxxxxxxxxxxxxxxxx]

Charly,

Assuming that the file that the trigger is on is journaled, the commit
should un-do whatever action occurred, including a delete of a record.  The
trigger will not re-fire.

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com






                    "Charly Jones"
                    <charly301@hotmail.       To:     midrange-l@midrange.com
                    com>                      cc:
                    Sent by:                  Subject:     triggers within 
commit cycles
                    midrange-l-admin@mi
                    drange.com


                    08/20/01 11:01 AM
                    Please respond to
                    midrange-l







Here are some dumb questions:

If I update a record in a file that has an update trigger, then rollback
the
transaction using commitment control, does the trigger program fire again
with the correct update that puts the record back like it was?

And does a delete that is rolled back fire the trigger program again, if
there is a delete trigger?

And does an add that is rolled back cause the trigger program to fire with
a
delete of the just added record?

Thanks a bunch,

Charly Jones
253 265-6244
Gig Harbor Washington




_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com