So, are you saying if I have a trigger for CUSTOMER but not for
CUSTOMER,CUSTOMER then the trigger won't work if some code looks like:
"TCL.CMD = \SELECT CUSTOMER WITH CLIENTNO = "6500" : @AM : \DELETE
CUSTOMER,CUSTOMER\ ; EXECUTE TCL.CMD CAPTURING OUTPUT"?
Hmmmm...
Bill
------------------------------------------------------------------------
----- Original Message -----
*From:* mbr...@epicor.com
*To:* U2 Users List <u2-users@listserver.u2ug.org>
*Date:* 8/16/2011 1:53 AM
*Subject:* Re: [U2] UD - Triggers
I have no problem with this on UD 7.2.
You do need to create the triggers e.g. DELETE on all partitions
CUSTOMER and CUSTOMER,NEWCUST and CUSTOMER,PREVCUST
CUSTOMER,CUSTOMER will also then be hit.
Similarly, if you put e.g. a DELETE trigger on CUSTOMER and
CUSTOMER,PREVCUST but not on CUSTOMER,NEWCUST and then create and delete
a record in CUSTOMER,NEWCUST it will not trigger - because there isn't
one set up at the partition level.
-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: 15 August 2011 19:37
To: U2 Mail List
Subject: [U2] UD - Triggers
Did anyone know that when one creates a trigger for a multi-level file,
and references the full file to delete or update a record, the triggers
_DON'T_ work. e.g.
CUSTOMERFILE
+ NEWCUST
+ PREVCUST
If I delete the "CUSTOMERFILE,CUSTOMERFILE" triggers don't work but they
do if I delete the "CUSTOMERFILE". So, I can't use multi-level files
for any file that contains triggers and whose DATA file name is
different than the file name. Therefore, beware on conversions.
I'm wondering if this is a bug or a feature? :-)
Bill
--------------------------------------------------------
Epicor Software (UK) is a limited company registered in England& Wales.
Registration Number: 2338274. Registered Office: Osborne Clarke OWA, One
London Wall, London EC2Y 5EB
This e-mail is for the use of the intended recipient(s) only. If you have
received this e-mail in error, please notify the sender immediately and then
delete it. If you are not the intended recipient, you must not use, disclose or
distribute this e-mail without the author's prior permission. We have taken
precautions to minimize the risk of transmitting software viruses, but we
advise you to carry out your own virus checks on any attachment to this
message. We cannot accept liability for any loss or damage caused by software
viruses. Any views and/or opinions expressed in this e-mail are of the author
only and do not represent the views of Epicor Software (UK) Limited or any
other company within its group.
This message has been scanned for malware by Websense. www.websense.com
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
