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