And I have absolutely no intention, whatsoever, under any circumstances, ever, at all, of putting a trigger on VOC.
C'mon guys, its the _VOC_!! There's no way I'm brave enough to try messing with the system at such a fundamental level. :-) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Tuesday, 31 August 2004 19:02 To: [EMAIL PROTECTED] Subject: RE: [U2] Dot Commands Bear in mind though that a trigger is a very intensive thing to add to a file. Just try timings on writes with and without them. Also you cannot replicate a file with triggers (major problem for use that I would LOVE IBM to fix.....) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael J Burbo Sent: 31 August 2004 03:59 To: [EMAIL PROTECTED] Subject: [U2] Dot Commands Mike, Another way to correct the "" or NULL saved item is to setup a Write Trigger and if the ID is NULL no write or replace with the person's logon and date/time this will also help you find who is causing your NULL items. A Trigger program can be set up an most any file and very good this to ensure history of changes are keep. If a change is made the Trigger program can write a copy of the original record into a <file.HIST> - Time and Date stamp it (User info too). You May also reformat some data items too. Michael Burbo [EMAIL PROTECTED] Media, PA 19063 610 358 9888 The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
