QTP Update question.....

[paddock]

Hi --

Another method is to update the file in the Output phase.  This avoids the "record has been changed" mechanism altogether, which, of course, leaves the database open to the "mysterious vanishing update" problem (which is what the "record has been changed" mechanism is designed to prevent!).

Anyway!  Modify your example code to something like this:

ACC *FROMPOLF &
  LINK TO RENEW-POL-MASTER OPT 

OUT POLICY-MASTER UPD &
  via POLICY-NO using POLICY-NO of FROMPOLF &
  ON ERRORS REPORT 
  ITEM P-VEH-VIN-NUMBER(1) FINAL VIN     IF P-VEH-VIN-NUMBER(1) = VINTO ELSE & 
       P-VEH-VIN-NUMBER(1)
etc...

I would also urge everyone to take the little extra time up-front and code the linkages explicitely.  Yes, it's just a little bit more work, but it saves the next maintenance programmer a *lot* of time in deciphering the mechanics.  It also insulates the code from changes to the underlying database structure which.

W. Paddock Smith
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.