QTP Query - add / update

[Reinke, Chuck]

An interesting approach might be:

Access A
Output B Add Update
Subfile C Keep If NewRecord Of B Include A 

-----Original Message-----
From: Terry Curran [mailto:terrycurran@onetel.net.uk]
Sent: Tuesday, September 24, 2002 2:26 AM
To: merol.newman@ramesys.com; Latimer, Richard
Cc: powerh-l@lists.swau.edu
Subject: RE: QTP Query - add / update


Even better would be to use

access file a link to file b opt
subfile sfname keep if not record file b exists include file a
output file b update add


-----Original Message-----
From: powerh-l-admin@cube.swau.edu
[mailto:powerh-l-admin@cube.swau.edu]On Behalf Of Merol Newman
Sent: 23 September 2002 21:28
To: Latimer, Richard
Cc: powerh-l@lists.swau.edu
Subject: RE: QTP Query - add / update


Hello Richard

Would this do?

access file a link to file b opt
subfile sfname keep if not record file b exists include file a
output file b update if record file b exists
output file b alias bb add if not record file b exists

I'm doing something very similar at the moment!

regards
Merol

merol.newman@ramesys.com
Ramesys, Eldon Way, Crick, Northamptonshire, UK. NN6 7SL
phone 01788 822133/823831, fax 01788 823601


-----Original Message-----
From: powerh-l-admin@cube.swau.edu
[mailto:powerh-l-admin@cube.swau.edu]On Behalf Of Latimer, Richard
Sent: 23 September 2002 21:03
To: PowerHouse List (E-mail)
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.


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.