[Bulk] How to update a Master table

[Ken Langendock]

You need to access the master file in the output phase.

 

Access TransFile

 

Sort (if necessary)

 

OUTPUT MasterFile &

   Add Update &

  NOITEMS & (if necessary)

  Via xxx using xxx

 

Item xxx of MasterFile initial xxx of TransFile

Item xxx of MasterFile FINAL xxx of TransFile

Etc.

 

 

That way it will update the master file for each transaction record and
never give you the "record has changed since you found it" message.

 

 

Ken

 

From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Jaime A
Sent: December 28, 2009 1:55 AM
To: powerh-l at lists.sowder.com
Subject: [Bulk] How to update a Master table

 

Hello,

 I want to process a transaction file and update the master file. The
   transaction file comes in with several transaction types which could be
add
   (if not in master), update (if in master) or delete. There might be
multiple update transaction which could depend on previous updates. So the
processing
   should be done in a certain sequence based on how the events happening. I
   know that if I use "Access Trans file link to Master File then do an
output
   at the end will give me an error as it will complain that I am accessing
a
   record that has been updated".  Please could somebody out there expert in
   Powerhouse's QTP suggests how to code this program so I could do an
   add/update/delete (not in that order) without the error message?
   Thanks in advance,
   jamie

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.722 / Virus Database: 270.14.122/2590 - Release Date: 12/28/09
02:16:00

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20091228/f3fafd72/attachment.htm