Hi, Problems on triggers comes when deleting a trigger while users are updating : if doing so, all future update of session which have opened file with trigger will fail if trigger has changed.
There has been a good mail on triggers months ago. Generally, it's better to put a master trigger (which never will change) and a slave trigger called by master. Management tasks on triggers could be done online on slave. True with UniVerse. Don't know with UniData. Cheers. Christian -----Message d'origine----- De : [email protected] [mailto:[email protected]] De la part de Jeffrey Butera Envoyé : mardi 14 juin 2011 17:16 À : [email protected] Objet : Re: [U2] UniData Triggers On 06/14/11 10:54, [email protected] wrote: > We are creating a trigger on a file that is used extensively in the > system. Is it necessary to logoff users when creating an update trigger > on a file or does UniData handle that when updating > the trigger information to the header of the file? The 'help' does not > specify whether trigger creation requires exclusive access to the file > or not. > I've had no issues setting up triggers on our production system with users logged in. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College [email protected] 413-559-5556 "...we must choose between what is right and what is easy..." Dumbledore _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ________________________________ Ce message et les pièces jointes sont confidentiels et réservés à l'usage exclusif de ses destinataires. Il peut également être protégé par le secret professionnel. Si vous recevez ce message par erreur, merci d'en avertir immédiatement l'expéditeur et de le détruire. L'intégrité du message ne pouvant être assurée sur Internet, la responsabilité du groupe Atos Origin ne pourra être recherchée quant au contenu de ce message. Bien que les meilleurs efforts soient faits pour maintenir cette transmission exempte de tout virus, l'expéditeur ne donne aucune garantie à cet égard et sa responsabilité ne saurait être recherchée pour tout dommage résultant d'un virus transmis. This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos Origin group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
