Hi Ken<br><br>Thanks for your prompt response. For using this method, it is assumed that you'll be updating straight from the transaction file, right? What if you need to access the master first, do some manipulation then update the master. After the initial access and update, if I encounter another "U"pdate transaction, will I be able to access the most current information (the one that I have updated before) and do any manipulation? What should I do in this case? Can I also do the addition and deletion (besides update) to the master file all in one request?<br>
<br>Thanks,<br>Jaime<br><br><div class="gmail_quote">On Mon, Dec 28, 2009 at 10:00 AM, <span dir="ltr"><<a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Send powerh-l mailing list submissions to<br>
<a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:powerh-l-owner@lists.sowder.com">powerh-l-owner@lists.sowder.com</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of powerh-l digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. How to update a Master table (Jaime A)<br>
2. RE:[Bulk] How to update a Master table (Ken Langendock)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Sun, 27 Dec 2009 22:54:52 -0800<br>
From: Jaime A <<a href="mailto:jarqueza@gmail.com">jarqueza@gmail.com</a>><br>
Subject: How to update a Master table<br>
To: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>
Message-ID:<br>
<<a href="mailto:3429621e0912272254h46477405gb0f24933ca10d323@mail.gmail.com">3429621e0912272254h46477405gb0f24933ca10d323@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
Hello,<br>
<br>
I want to process a transaction file and update the master file. The<br>
transaction file comes in with several transaction types which could be<br>
add<br>
(if not in master), update (if in master) or delete. There might be<br>
multiple update transaction which could depend on previous updates. So the<br>
processing<br>
should be done in a certain sequence based on how the events happening. I<br>
know that if I use "Access Trans file link to Master File then do an<br>
output<br>
at the end will give me an error as it will complain that I am accessing<br>
a<br>
record that has been updated". Please could somebody out there expert in<br>
Powerhouse's QTP suggests how to code this program so I could do an<br>
add/update/delete (not in that order) without the error message?<br>
Thanks in advance,<br>
jamie<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://lists.sowder.com/pipermail/powerh-l/attachments/20091227/bba2c28a/attachment-0001.html" target="_blank">http://lists.sowder.com/pipermail/powerh-l/attachments/20091227/bba2c28a/attachment-0001.html</a><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Mon, 28 Dec 2009 12:48:16 -0500<br>
From: "Ken Langendock" <<a href="mailto:ken.langendock@rogers.com">ken.langendock@rogers.com</a>><br>
Subject: RE: [Bulk] How to update a Master table<br>
To: "'Jaime A'" <<a href="mailto:jarqueza@gmail.com">jarqueza@gmail.com</a>>, <<a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>><br>
Message-ID: <000f01ca87e5$ef424a40$cdc6dec0$@<a href="mailto:langendock@rogers.com">langendock@rogers.com</a>><br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
You need to access the master file in the output phase.<br>
<br>
<br>
<br>
Access TransFile<br>
<br>
<br>
<br>
Sort (if necessary)<br>
<br>
<br>
<br>
OUTPUT MasterFile &<br>
<br>
Add Update &<br>
<br>
NOITEMS & (if necessary)<br>
<br>
Via xxx using xxx<br>
<br>
<br>
<br>
Item xxx of MasterFile initial xxx of TransFile<br>
<br>
Item xxx of MasterFile FINAL xxx of TransFile<br>
<br>
Etc.<br>
<br>
<br>
<br>
<br>
<br>
That way it will update the master file for each transaction record and<br>
never give you the "record has changed since you found it" message.<br>
<br>
<br>
<br>
<br>
<br>
Ken<br>
<br>
<br>
<br>
From: powerh-l-bounces+ken.langendock=<a href="http://rogers.com" target="_blank">rogers.com</a>@<a href="http://lists.sowder.com" target="_blank">lists.sowder.com</a><br>
[mailto:<a href="mailto:powerh-l-bounces%2Bken.langendock">powerh-l-bounces+ken.langendock</a>=<a href="http://rogers.com" target="_blank">rogers.com</a>@<a href="http://lists.sowder.com" target="_blank">lists.sowder.com</a>] On<br>
Behalf Of Jaime A<br>
Sent: December 28, 2009 1:55 AM<br>
To: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>
Subject: [Bulk] How to update a Master table<br>
<br>
<br>
<br>
Hello,<br>
<br>
I want to process a transaction file and update the master file. The<br>
transaction file comes in with several transaction types which could be<br>
add<br>
(if not in master), update (if in master) or delete. There might be<br>
multiple update transaction which could depend on previous updates. So the<br>
processing<br>
should be done in a certain sequence based on how the events happening. I<br>
know that if I use "Access Trans file link to Master File then do an<br>
output<br>
at the end will give me an error as it will complain that I am accessing<br>
a<br>
record that has been updated". Please could somebody out there expert in<br>
Powerhouse's QTP suggests how to code this program so I could do an<br>
add/update/delete (not in that order) without the error message?<br>
Thanks in advance,<br>
jamie<br>
<br>
No virus found in this incoming message.<br>
Checked by AVG - <a href="http://www.avg.com" target="_blank">www.avg.com</a><br>
Version: 9.0.722 / Virus Database: 270.14.122/2590 - Release Date: 12/28/09<br>
02:16:00<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://lists.sowder.com/pipermail/powerh-l/attachments/20091228/f3fafd72/attachment-0001.htm" target="_blank">http://lists.sowder.com/pipermail/powerh-l/attachments/20091228/f3fafd72/attachment-0001.htm</a><br>
<br>
------------------------------<br>
<br>
--<br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>
Mailing list: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>
Subscribe: &quot;subscribe&quot; in message body to <a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>
Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to <a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>
<a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>
This list is closed, thus to post to the list you must be a subscriber.<br>
Add 'site:<a href="http://lists.sowder.com" target="_blank">lists.sowder.com</a> powerh-l' to your search terms to search the list archive at Google.<br>
<br>
End of powerh-l Digest, Vol 55, Issue 5<br>
***************************************<br>
</blockquote></div><br>