What locking needs to be implemented in a uv basic trigger (after insert update ) in order to be able to successfully complete an SQL UPDATE of a table with the trigger? The trigger runs great with basic programs or the editor doing the updating. The problem seems to only occur with an SQL UPDATE etc.
I am getting the message Program "*THE.TRIGGER": Line 410, FATAL: The locks necessary for database operations at the current isolation level (2) are not held by this process. Error performing trigger for "HOLDINGS/HOLDINGS". UniVerse/SQL: Attempt to update file "HOLDINGS", record ABC failed. Thanks, john This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
