QTP Update question.....

Lafferty, Mike Mike.Lafferty@AIG.COM
Tue, 23 Jan 2001 09:46:27 -0500


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0854B.43C2B890
Content-Type: text/plain;
	charset="iso-8859-1"

Good morning all,
     I had posted a QUICK SELECTBOX question about 3 weeks ago, on which I
am still working and making great strides, thanks to everyone's wonderful
assistance....I'll let you know how that one turns out, when I get back to
it (you all know about 'shifting gears' in the software world)....meaning
I've been taken off that to work on something else more pressing.....

In the meantime, I have turned my attention to some QTP updates....The
situation is this....It's an automobile insurance application....I link the
POLICY-NO from the subfile to the POLICY-NO of the POLICY-MASTER dataset and
update the appropriate VIN numbers (up to OCCURS 6) for that policy....while
doing this, I encountered the error message "Record has been changed since
you last found it"....This occurs when I have more than one vehicle per
policy....Each subfile record contains a POLICY-NO, a VIN and a VINTO to do
a compare....I listed some example data from the subfile below....I have
tried several alternatives including OUTPUT AT FINAL and OUTPUT AT POLICY-NO
and also some DEFINES for the array values thinking QTP was not evaluating
them properly, all to no avail.....Maybe my approach to the problem is a
little lopsided....
We're running PH version 6.09D on a HP3000 979-100.....

I think I need some help ! (tongue-in-cheek)......


SET DICT FROMDDC                                                   
REQ VINUPDT INPUT LIMIT 100000
&
            ON CALCULATION ERRORS REPORT
&
            ON EDIT ERRORS REPORT
SET LOCK FILE UPDATE
ACC *FROMPOLF LINK TO POLICY-MASTER LINK TO RENEW-POL-MASTER OPT

OUT POLICY-MASTER UPD ON ERRORS REPORT &
  ITEM P-VEH-VIN-NUMBER(1) FINAL VIN     IF P-VEH-VIN-NUMBER(1) = VINTO ELSE
&
       P-VEH-VIN-NUMBER(1)
  ITEM P-VEH-VIN-NUMBER(2) FINAL VIN     IF P-VEH-VIN-NUMBER(2) = VINTO ELSE
&
       P-VEH-VIN-NUMBER(2)
  ITEM P-VEH-VIN-NUMBER(3) FINAL VIN     IF P-VEH-VIN-NUMBER(3) = VINTO ELSE
&
       P-VEH-VIN-NUMBER(3)
  ITEM P-VEH-VIN-NUMBER(4) FINAL VIN     IF P-VEH-VIN-NUMBER(4) = VINTO ELSE
&
       P-VEH-VIN-NUMBER(4)
  ITEM P-VEH-VIN-NUMBER(5) FINAL VIN     IF P-VEH-VIN-NUMBER(5) = VINTO ELSE
&
       P-VEH-VIN-NUMBER(5)
  ITEM P-VEH-VIN-NUMBER(6) FINAL VIN     IF P-VEH-VIN-NUMBER(6) = VINTO ELSE
&
       P-VEH-VIN-NUMBER(6)



POLICY-NO  VIN                VINTO

    1000173    1B3BE46KXHC289815  1B3BBE46KYXH89815
    1000377    1P3XP24D9NN190832  1P3X924D9NN190832
    1000576    1G2AF54T9L6202569  1G2AF54T926202569
    1000695    1P3BP36D1HF143256  1P3PB36D1HF143236
    1001335    2FTJW36L5ECA90915  2FTJW365ELA90915
    1001437    1GBFG15R6T1020579  1GBFG15R6T1020597
    1001618    1B3BE46D2FC201855  1B3BE462DFC201855
    1001618    1G1BN53E0NR118754  1G1BN530NR118754
    1002565    1C3BF66P4HX793597  1C38F66P4HX793597
    1004476    1G3HY54C8L1807541  IG3HY54C8L1807541
    1004654    1C3CJ51K1JG366618  1C3CJ51K1JG36661B
    1004693    SAJHX6247WC815550  SAJHK6247WC815550
    1004969    1FTHF25Y3GKA72854  1FTHF25Y36KA72854
    1005177    1B3XA46K3PF543136  183XA46K3PF543136
    1005335    WDBCB20A8DB049998  WDBCB20A8D049998
    1005522    1FALP52U3SA273426  1FLAP52U3SA273426
    1005527    1B7GN14M1HS423074  1876N14M1H5423074
    1005635    1G1ND52J5Y6273384  161ND52J5Y6273384
    1005772    1B3EJ46X9VN656093  AB3EJ46X9VN656093

------_=_NextPart_001_01C0854B.43C2B890
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">



QTP Update question.....



Good morning all,
     I had posted = a QUICK SELECTBOX question about 3 weeks ago, on which I am still = working and making great strides, thanks to everyone's wonderful = assistance....I'll let you know how that one turns out, when I get back = to it (you all know about 'shifting gears' in the software = world)....meaning I've been taken off that to work on something else = more pressing.....

In the meantime, I have turned my = attention to some QTP updates....The situation is this....It's an = automobile insurance application....I link the POLICY-NO from the = subfile to the POLICY-NO of the POLICY-MASTER dataset and update the = appropriate VIN numbers (up to OCCURS 6) for that policy....while doing = this, I encountered the error message "Record has been changed since = you last found it"....This occurs when I have more than one vehicle per = policy....Each subfile record contains a POLICY-NO, a VIN and a VINTO = to do a compare....I listed some example data from the subfile = below....I have tried several alternatives including OUTPUT AT FINAL = and OUTPUT AT POLICY-NO and also some DEFINES for the array values = thinking QTP was not evaluating them properly, all to no = avail.....Maybe my approach to the problem is a little = lopsided....

We're running PH version 6.09D on a = HP3000 979-100.....

I think I need some help ! = (tongue-in-cheek)......


SET DICT = FROMDDC           = ;            = ;            = ;            = ;   
REQ VINUPDT INPUT LIMIT = 100000           =             =             =             = &
         &n= bsp;  ON CALCULATION ERRORS = REPORT           =             =             =   &
         &n= bsp;  ON EDIT ERRORS REPORT
SET LOCK FILE UPDATE
ACC *FROMPOLF LINK TO POLICY-MASTER = LINK TO RENEW-POL-MASTER OPT

OUT POLICY-MASTER UPD ON ERRORS = REPORT &
  ITEM P-VEH-VIN-NUMBER(1) = FINAL VIN     IF P-VEH-VIN-NUMBER(1) =3D VINTO ELSE = &
       = P-VEH-VIN-NUMBER(1)
  ITEM P-VEH-VIN-NUMBER(2) = FINAL VIN     IF P-VEH-VIN-NUMBER(2) =3D VINTO ELSE = &
       = P-VEH-VIN-NUMBER(2)
  ITEM P-VEH-VIN-NUMBER(3) = FINAL VIN     IF P-VEH-VIN-NUMBER(3) =3D VINTO ELSE = &
       = P-VEH-VIN-NUMBER(3)
  ITEM P-VEH-VIN-NUMBER(4) = FINAL VIN     IF P-VEH-VIN-NUMBER(4) =3D VINTO ELSE = &
       = P-VEH-VIN-NUMBER(4)
  ITEM P-VEH-VIN-NUMBER(5) = FINAL VIN     IF P-VEH-VIN-NUMBER(5) =3D VINTO ELSE = &
       = P-VEH-VIN-NUMBER(5)
  ITEM P-VEH-VIN-NUMBER(6) = FINAL VIN     IF P-VEH-VIN-NUMBER(6) =3D VINTO ELSE = &
       = P-VEH-VIN-NUMBER(6)



POLICY-NO  = VIN           &nb= sp;    VINTO

    = 1000173    1B3BE46KXHC289815  = 1B3BBE46KYXH89815
    = 1000377    1P3XP24D9NN190832  = 1P3X924D9NN190832
    = 1000576    1G2AF54T9L6202569  = 1G2AF54T926202569
    = 1000695    1P3BP36D1HF143256  = 1P3PB36D1HF143236
    = 1001335    2FTJW36L5ECA90915  = 2FTJW365ELA90915
    = 1001437    1GBFG15R6T1020579  = 1GBFG15R6T1020597
    1001618    1B3BE46D2FC201855  = 1B3BE462DFC201855
    1001618    1G1BN53E0NR118754  = 1G1BN530NR118754
    = 1002565    1C3BF66P4HX793597  = 1C38F66P4HX793597
    = 1004476    1G3HY54C8L1807541  = IG3HY54C8L1807541
    = 1004654    1C3CJ51K1JG366618  = 1C3CJ51K1JG36661B
    = 1004693    SAJHX6247WC815550  = SAJHK6247WC815550
    = 1004969    1FTHF25Y3GKA72854  = 1FTHF25Y36KA72854
    = 1005177    1B3XA46K3PF543136  = 183XA46K3PF543136
    = 1005335    WDBCB20A8DB049998  = WDBCB20A8D049998
    = 1005522    1FALP52U3SA273426  = 1FLAP52U3SA273426
    = 1005527    1B7GN14M1HS423074  = 1876N14M1H5423074
    = 1005635    1G1ND52J5Y6273384  = 161ND52J5Y6273384
    = 1005772    1B3EJ46X9VN656093  = AB3EJ46X9VN656093

------_=_NextPart_001_01C0854B.43C2B890-- = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 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.