Update Master File

Wed Dec 30 07:02:24 CST 2009

Hi Jamie:

  You may want to put a Select after your Output Delete.

  In the following code we will delete one record if the two conditions are true.
  the 'on error report' allows QTP to continue even if it could not find a record to delete.

  ii) output masterfile delete alias master2 viaindex partno
using partno of trans_file &

if activitycode of masterfile = "D" on errors report

select master2 if activitycode of master2 = "D"

Happy New Year,
Peter Bateman

From: ken.langendock at rogers.com
To: jarqueza at gmail.com; powerh-l at lists.sowder.com
Subject: RE: [Bulk] Re: Update Master File
Date: Tue, 29 Dec 2009 14:25:47 -0500

See below

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 29, 2009 2:07 PM

To: powerh-l at lists.sowder.com

Subject: [Bulk] Re: Update Master File

Hi Ken

I've tried and still getting error during compilation. Here is my situation:

1. My Master file has two index key, one is activity_key
(partno+activitycode+activitydate+activitytime), this is defined as unique. The
other index key is a repeating index on partno.

2. In one request, I have two outputs:

     i) output masterfile add update alias master1 viaindex
activity_key using partno of trans_file+

activitycode of trans_file + activitydate of trans_file + activitytime of
trans_file &

if transcode of trans_file = "U" or transcode of trans_file =
"A"

    ii) output masterfile delete alias master2 viaindex partno
using partno of trans_file &

                                       ; 
if activitycode of master2 = "D"

if activitycode of masterfile = "D"

For the above code, I got the following error:

1. *E* Cant find the file for item named activitycode of master2.

2. *W* Linkage should be via a unique index if the file is output only.

Please could you help me to correct my program code? For the delete, I want to
delete those with the same partno and activitycode of master file =
"D". 

Thanks,

Jaime

On Mon, Dec 28, 2009 at 10:00 AM, <powerh-l-request at lists.sowder.com>
wrote:

Send powerh-l mailing list submissions to

       powerh-l at lists.sowder.com

To subscribe or unsubscribe via the World Wide Web, visit

       http://lists.sowder.com/mailman/listinfo/powerh-l

or, via email, send a message with subject or body 'help' to

       powerh-l-request at lists.sowder.com

You can reach the person managing the list at

       powerh-l-owner at lists.sowder.com

When replying, please edit your Subject line so it is more specific

than "Re: Contents of powerh-l digest..."

Today's Topics:

  1. How to update a Master table (Jaime A)

  2. RE:[Bulk] How to update a Master table (Ken Langendock)

----------------------------------------------------------------------

Message: 1

Date: Sun, 27 Dec 2009 22:54:52 -0800

From: Jaime A <jarqueza at gmail.com>

Subject: How to update a Master table

To: powerh-l at lists.sowder.com

Message-ID:

       <3429621e0912272254h46477405gb0f24933ca10d323 at mail.gmail.com>

Content-Type: text/plain; charset="iso-8859-1"

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

-------------- next part --------------

An HTML attachment was scrubbed...

URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20091227/bba2c28a/attachment-0001.html

------------------------------

Message: 2

Date: Mon, 28 Dec 2009 12:48:16 -0500

From: "Ken Langendock" <ken.langendock at rogers.com>

Subject: RE: [Bulk] How to update a Master table

To: "'Jaime A'" <jarqueza at gmail.com>,
<powerh-l at lists.sowder.com>

Message-ID: <000f01ca87e5$ef424a40$cdc6dec0$@langendock at rogers.com>

Content-Type: text/plain; charset="us-ascii"

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-0001.htm

------------------------------

--

= = = = = = = = = = = = = = = = = = = = = = = = = = = =

Mailing list: powerh-l at lists.sowder.com

Subscribe: &quot;subscribe&quot; in message body to powerh-l-request at lists.sowder.com

Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; 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.

End of powerh-l Digest, Vol 55, Issue 5

***************************************

No virus
found in this incoming message.

Checked by AVG - www.avg.com

Version: 9.0.722 / Virus Database: 270.14.123/2592 - Release Date: 12/29/09
02:47:00

_________________________________________________________________
Windows Live: Keep your friends up to date with what you do online.
http://go.microsoft.com/?linkid=9691815
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20091230/3d6f1ba6/attachment.htm 