QTP

[Mike Palandri]

Hi,

Not sure if this is the exact situation, but it sounds similar:

When I've run into this message it is usually because I've linked a "one"
file to a "many" file, resulting in a record complex that contains
several occurrences of the "one" record, and I'm trying to update or
delete the "one" record.  E.g. below, if MASTER has a unique key and
there are multiple DETAILS per MASTER, 

ACCESS MASTER LINK TO DETAIL

you might end up with a complex like this:

Master		Detail			Detail
Key		key			Other
123 		123,AAA		zzz
123		123,BBB		yyy
123		123,CCC		zzz

If I coded:

SELECT IF DETAIL-OTHER = "zzz"
OUTPUT MASTER DELETE

QTP would delete the MASTER record "123" when it processed the first
record in the complex, then report the "Record has been changed since you
found it" message when it tried to delete master "123" again as it
processed the third record in the complex, since a MASTER with that key
value has already been deleted (or marked as deleted.)  The way I've
worked around this in the past is to sort the complex and OUTPUT AT:


ACCESS MASTER LINK TO DETAIL
SELECT IF DETAIL-OTHER = "zzz"
SORT ON MASTER-KEY
OUTPUT MASTER DELETE AT MASTER-KEY




At 11:14 AM 10/19/1999 +0000, Al Karman wrote:
>Greetings, fellow Power-l's:
>
>I've come across something that doesn't seem to make sense in QTP
<insert 
>warning to suppress humor here>!
>
>I've got a subfile of claims records linking back to the IMAGE detail of

>same.  I want to delete the subfile record if it meets certain
conditions 
>contained in the detail record matching it.  There is no uniqueness
inherent 
>in the keys, unfortunately, so I've devised a scheme using dates, etc.
in 
>the comparison to ensure I've got the correct detail record.
>
>Here's the doesn't make sense part....using the subfile to detail
linkage, 
>with deleting qualifying subfile records, I get the following error
message, 
>followed by QTP run terminated:
>
>           Record has been changed since you found it.
>
>It shows the subfile, and the linkitems.  And, as nearly as I can tell, 
>doesn't make sense as I'm the only user in this account.
>
>Is there something else going on that helps supply an inappropriate
error 
>message???
>
>TIA,
>
>
>           '''''''''''''''''''''''''''''''''''''''
>           '             Al Karman               '
>           '  Information Technology Consulting  '
>           '   Internet:  alkarman@hotmail.com   '
>           '        FAX:  248.671.5035           '
>           '''''''''''''''''''''''''''''''''''''''
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com
>= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
= =
>Subscribe: "subscribe powerh-l" in message body to
majordomo@lists.swau.edu
>Unsubscribe: "unsubscribe powerh-l" in message to
majordomo@lists.swau.edu
>This list is closed, thus to post to the list, you must be a subscriber.
>

Mike