[Michael Cousins]

Locks and unqualified updates.

The compiled code defaults to SET LOCK FILE RUN

The uncompile code defaults to SET LOCK FILE UPDATE

The code likely tries to OUTPUT UPDATE a record from the ACCESS statement 
more than once, the result of a one - to - many relationship. 

Qualify the OUTPUT with a SELECT that will ensure any one record is only 
updated once.

/mc
Michael Cousins
Global Response Team
IBM Software Group, Information Management
michael.cousins at ca.ibm.com
613.356.5811







lorcan-computers at fsmail.net 
Sent by: powerh-l-bounces+michael.cousins=ca.ibm.com at lists.sowder.com
11/12/2009 02:35 AM
Please respond to
lorcan-computers at fsmail.net


To
powerhouse <powerh-l at lists.sowder.com>
cc

Subject







Hi Guys,
Hoping you can help me.
I have a piece of compiled QTP which run's within a job on a HP3000 and it 
errors with a 'Record has changed since you found it' error. I have run 
the QTP outside of the job and get the same error, but if I run the 
uncompiled code it completes without a problem. I have recompiled the 
source to ensure that the version in the job was compiled using the same 
source ( I hope this makes sense and doesn't get confusing) and reran 
getting the same error. So basically, compiled version errors, uncompiled 
completes successfully
Any ideas ?
Cheers
 
Ron

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to 
powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to 
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the 
list archive at Google.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20091112/46982ace/attachment.htm