QTP Query - add / update

[Frank Huizinga]

This is an other solution for your problem

Access A

Output B Add Update

Subfile C Keep If Newrecord Of B Include A

Before any out is performed, Qtp tries to read B first to determine if de
output must be add or update, so at the time Qtp performs the subfile
statement, B has been read in advance.

 
Regards,

Frank Huizinga
Solipsis BV, Holland

-----Original Message-----
From: Latimer, Richard
To: PowerHouse List (E-mail)
Sent: 23-9-02 22:03
Subject: QTP Query - add / update

Greetings listers . . .

I have a QTP that is doing an add / update to a file. 
eg
access file a
output file b add / update
  

I want to be able to subfile the records that added for exeception
reporting
(update is the normal case) so is there an easy method of telling if I
added
a new record or updated an existing one ?


thanks
Richard Latimer
Airways New Zealand


**********************************************************************
This electronic message together with any attachments is confidential.
If
you receive it in error: (i) you must not use, disclose, copy or retain
it; (ii) please contact the sender immediately by reply email and then
delete the emails. Views expressed in this email may not be those of the
Airways Corporation of New Zealand Limited
**********************************************************************


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.