Error updating master file

[Peter Bateman]

Hi Jaime:
    
   The problem is that you have read the master_file in the access statement
   and have  updated it in an OUTPUT statement.
   When that happens QTP creates a two pass request.
      1) Write all the input to disk i.e. QTPSCR.
      2) Read QTPSCR and process ITEM and OUTPUT statements.
   
   QTP uses the checksum from the access statement in pass 1 to compare with
   the checksum of the record it has read just before the update.
      
   So if you have linked to a record more than one in the access statement
   and you try to update it more than once you will get the message. The
   checksums don't match because you have changed the file on the first 
   execution of the OUTPUT statement for that link value.
 
   You can use an ALIAS your master_file in the OUTPUT statement
   This will cause the QTP to read the master_file twice during the execution
   of the OUTPUT statement. QTP uses the checksum from the first ALIAS read
   to compare with the checksum of the record it has read just before the update.
   
    It is a good idea to include a VIA clause on your
    OUTPUT <master> UPDATE. Otherwise QTP will use a record number to
    re-read the master. Your record may have migrated since the
    access was executed. 
    
 Regards,
 Peter Bateman
    > From: markus.grossrieder at tele2.ch> To: jarqueza at gmail.com; powerh-l at lists.sowder.com> Subject: Re: Error updating master file> Date: Sun, 10 Aug 2008 13:26:24 +0200> > Hi Jaime,> > you need to put a sort (or sorted) command, then add the "at sortkey" option > to your output,> something like this (air code):> > access file-A link to master_file opt> sort on file-A-key> ...> output master_file update add at file-A-key> item field_1 final d_field> > HTH, regards,> Markus> > ----- Original Message ----- > From: Jaime A> To: powerh-l at lists.sowder.com> Sent: Sunday, August 10, 2008 7:48 AM> Subject: Help: Error updating master file> > > > > > Hi> > I need help to update a file. Here is my program> > access file-A link to master_file opt> > contains some manipulation> > output master_file update add> item field_1 final d_field> > When I run the above program, it will bomb saying the record being updated > has been changed.> > The relationship of file-A to master_file is many-to-one. How would I be > able to update my master_file ?> > Thanks in advance,> Jaime> > Hi> > > > No virus found in this incoming message.> Checked by AVG - http://www.avg.com> Version: 8.0.138 / Virus Database: 270.6.0/1602 - Release Date: 8/9/2008 > 1:22 PM> > > > > -- > = = = = = = = = = = = = = = = = = = = = = = = = = = = => 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. > > -- > = = = = = = = = = = = = = = = = = = = = = = = = = = = => 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.
_________________________________________________________________
Find hidden words, unscramble celebrity names, or try the ultimate crossword puzzle with Live Search Games. Play now!
http://g.msn.ca/ca55/212
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20080811/3b079386/attachment.htm