Triggers don't work against Q pointers. Robert Paterson Technology Support Manager www.epicor.com Tel.: +44 (1344) 468231 Cell: +44 (7799) 348513 Fax: +44 (1344) 468050 E-Mail: [EMAIL PROTECTED]
1 The Arena, Downshire Way, Bracknell, Berks, UK, RG12 1PU 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. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 26 August 2004 14:57 To: [EMAIL PROTECTED] Subject: [U2] Trigger problem! I have a situation in which I need to store data to be moved elsewhere I have a working trigger attached to a local file - works brilliantly LIST.SICA TRX-TRANSACTIONS 03:45:34pm 26 Aug 2004 Page 1 ========================================== Sica Region for Data File "TRX-TRANS000" Revision: 4 Trigger "SYNCH.TRIGGER" is enabled, creator is "dennis". calls "*KO.OP*SYNCH.TRIGGER" for Row After Insert Update Delete I have some users accessing the file from the local account, ie the VOC pointer is an F TRX-TRANSACTIONS 001 F 002 TRX-TRANS000 003 D_TRX-TRANS000 But other users need to access the file from other accounts, ie the VOC entry is a Q (in this example I have called the Q file "QTRIGGER") QTRIGGER 001 Q 002 KO.OP 003 TRX-TRANSACTIONS And a LIST.SICA on the Q pointer produces LIST.SICA QTRIGGER 03:50:45pm 26 Aug 2004 Page 1 ========================================== Sica Region for Data File "TRX-TRANS000" Revision: 4 Trigger "SYNCH.TRIGGER" is enabled, creator is "dennis". calls "*KO.OP*SYNCH.TRIGGER" for Row After Insert Update Delete However, when I add data to the local file, the trigger kicks in when I add data to the QFILE, the trigger doesn't happen any ideas? <PRE> --------------------------------------------------------- GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp</PRE> ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
