SQL Isolation Level 2 is known as "Committed Read" level. What this implies is that will ensure that you won't have lost updates and no dirty reads.
It implies that you need to have shared locks on any data that has been read (or written), to ensure that some other process hasn't changed that data value (thus making it "dirty") during your transaction. By attempting to get the shared lock, you will wait until any outstanding transactions on that read will complete, and you will then prevent any attempts to write/modify that value until you have completed. Basically, any data you need to use READL instead of READ statements within the trigger. Dave At 08:35 AM 7/22/2004 -0400, you wrote: >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/ ======================================================================== David T. Meeks || "All my life I'm taken by surprise Architect, Technology Office || I'm someone's waste of time Ascential Software || Now I walk a balanced line [EMAIL PROTECTED] || and step into tomorrow" - IQ ======================================================================== ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
