Solution: Using ALTEREDRECORD in QTP

David Morrison - Corporate dmorrison@mcbrideelectric.com
Fri, 1 Aug 2003 11:27:03 -0700


I tried using ALTEREDRECORD to condition the output of a temporary subfile (containing the vendor key fields), right after the ITEM statements.  This subfile can be used in a second request to go back and update the vendor record.  This seemed to work properly, if inelegantly.

Thanks.

-----Original Message-----
From: David Morrison - Corporate 
Sent: Friday, August 01, 2003 11:11 AM
To: powerh-l@lists.swau.edu
Subject: Using ALTEREDRECORD in QTP


I'm running PH607F on an iSeries (AS/400).  I'm not sure if that matters or not.

Here's my test program, carved out of a much larger one with lots of ITEM statements:

------------
                                                        
access spo_vendor_master                                
                                                        
choose company_number "001", location_number "013", &   
       vendor_number "GRAY01"                           
                                                        
output spo_vendor_master UPDATE                         
  ITEM vendor_zip FINAL vendor_zip + 1                  
  ITEM vendor_maintained_date     FINAL SYSDATE      &  
       IF ALTEREDRECORD OF spo_vendor_master    
  
----------

When executed, the test program updates the ZIP code in the vendor master, but doesn't update the maintained date.

1. Shouldn't it?  If not, when WOULD you use ALTEREDRECORD in QTP?
2. If it shouldn't, is there an easy alternative?  

Thanks.

David Morrison                

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" 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.


_________________________________________________
Scanned on 01 Aug 2003 18:22:50
Scanning by http://erado.com