QTP Update question.....
SD
simopoulos@scoplife.gr
Tue, 23 Jan 2001 17:37:07 +0200
This is a multi-part message in MIME format.
------=_NextPart_000_006C_01C08563.1B88CAA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
QTP Update question.....RENEW-POL-MASTER OPTIONAL ?
I think you are trying to update record again, because of linkage.
----- Original Message -----=20
From: Lafferty, Mike=20
To: 'powerh-l@sphere.swau.edu'=20
Sent: Tuesday, January 23, 2001 4:46 PM
Subject: QTP Update question.....
Good morning all,=20
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.....=20
I think I need some help ! (tongue-in-cheek)......=20
SET DICT FROMDDC =20
REQ VINUPDT INPUT LIMIT 100000 =
&=20
ON CALCULATION ERRORS REPORT =
&=20
ON EDIT ERRORS REPORT=20
SET LOCK FILE UPDATE=20
ACC *FROMPOLF LINK TO POLICY-MASTER LINK TO RENEW-POL-MASTER OPT=20
OUT POLICY-MASTER UPD ON ERRORS REPORT &=20
ITEM P-VEH-VIN-NUMBER(1) FINAL VIN IF P-VEH-VIN-NUMBER(1) =3D =
VINTO ELSE &=20
P-VEH-VIN-NUMBER(1)=20
ITEM P-VEH-VIN-NUMBER(2) FINAL VIN IF P-VEH-VIN-NUMBER(2) =3D =
VINTO ELSE &=20
P-VEH-VIN-NUMBER(2)=20
ITEM P-VEH-VIN-NUMBER(3) FINAL VIN IF P-VEH-VIN-NUMBER(3) =3D =
VINTO ELSE &=20
P-VEH-VIN-NUMBER(3)=20
ITEM P-VEH-VIN-NUMBER(4) FINAL VIN IF P-VEH-VIN-NUMBER(4) =3D =
VINTO ELSE &=20
P-VEH-VIN-NUMBER(4)=20
ITEM P-VEH-VIN-NUMBER(5) FINAL VIN IF P-VEH-VIN-NUMBER(5) =3D =
VINTO ELSE &=20
P-VEH-VIN-NUMBER(5)=20
ITEM P-VEH-VIN-NUMBER(6) FINAL VIN IF P-VEH-VIN-NUMBER(6) =3D =
VINTO ELSE &=20
P-VEH-VIN-NUMBER(6)=20
POLICY-NO VIN VINTO=20
1000173 1B3BE46KXHC289815 1B3BBE46KYXH89815=20
1000377 1P3XP24D9NN190832 1P3X924D9NN190832=20
1000576 1G2AF54T9L6202569 1G2AF54T926202569=20
1000695 1P3BP36D1HF143256 1P3PB36D1HF143236=20
1001335 2FTJW36L5ECA90915 2FTJW365ELA90915=20
1001437 1GBFG15R6T1020579 1GBFG15R6T1020597=20
1001618 1B3BE46D2FC201855 1B3BE462DFC201855=20
1001618 1G1BN53E0NR118754 1G1BN530NR118754=20
1002565 1C3BF66P4HX793597 1C38F66P4HX793597=20
1004476 1G3HY54C8L1807541 IG3HY54C8L1807541=20
1004654 1C3CJ51K1JG366618 1C3CJ51K1JG36661B=20
1004693 SAJHX6247WC815550 SAJHK6247WC815550=20
1004969 1FTHF25Y3GKA72854 1FTHF25Y36KA72854=20
1005177 1B3XA46K3PF543136 183XA46K3PF543136=20
1005335 WDBCB20A8DB049998 WDBCB20A8D049998=20
1005522 1FALP52U3SA273426 1FLAP52U3SA273426=20
1005527 1B7GN14M1HS423074 1876N14M1H5423074=20
1005635 1G1ND52J5Y6273384 161ND52J5Y6273384=20
1005772 1B3EJ46X9VN656093 AB3EJ46X9VN656093=20
------=_NextPart_000_006C_01C08563.1B88CAA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>QTP Update question.....</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3103.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>RENEW-POL-MASTER OPTIONAL =
?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I think you are trying to =
update record again,=20
because of linkage.</FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A href=3D"mailto:Mike.Lafferty@AIG.COM" =
title=3DMike.Lafferty@AIG.COM>Lafferty,=20
Mike</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
href=3D"mailto:'powerh-l@sphere.swau.edu'"=20
title=3Dpowerh-l@sphere.swau.edu>'powerh-l@sphere.swau.edu'</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, January 23, 2001 =
4:46=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> QTP Update =
question.....</DIV>
<DIV><BR></DIV>
<P><FONT face=3DArial size=3D2>Good morning all,</FONT> <BR><FONT =
face=3DArial=20
size=3D2> I had posted a QUICK SELECTBOX =
question about=20
3 weeks ago, on which I am still working and making great strides, =
thanks to=20
everyone's wonderful assistance....I'll let you know how that one =
turns out,=20
when I get back to it (you all know about 'shifting gears' in the =
software=20
world)....meaning I've been taken off that to work on something else =
more=20
pressing.....</FONT></P>
<P><FONT face=3DArial size=3D2>In the meantime, I have turned my =
attention to some=20
QTP updates....The situation is this....It's an automobile insurance=20
application....I link the POLICY-NO from the subfile to the POLICY-NO =
of the=20
POLICY-MASTER dataset and update the appropriate VIN numbers (up to =
OCCURS 6)=20
for that policy....while doing this, I encountered the error message =
"Record=20
has been changed since you last found it"....This occurs when I have =
more than=20
one vehicle per policy....Each subfile record contains a POLICY-NO, a =
VIN and=20
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=20
OUTPUT AT POLICY-NO and also some DEFINES for the array values =
thinking QTP=20
was not evaluating them properly, all to no avail.....Maybe my =
approach to the=20
problem is a little lopsided....</FONT></P>
<P><FONT face=3DArial size=3D2>We're running PH version 6.09D on a =
HP3000=20
979-100.....</FONT> </P>
<P><FONT face=3DArial size=3D2>I think I need some help !=20
(tongue-in-cheek)......</FONT> </P><BR>
<P><FONT face=3Dr_ansi size=3D2>SET DICT=20
=
FROMDDC =
&=
nbsp; &n=
bsp; &nb=
sp; =20
</FONT><BR><FONT face=3Dr_ansi size=3D2>REQ VINUPDT INPUT LIMIT=20
=
100000 &=
nbsp; &n=
bsp; &nb=
sp; =20
&</FONT> <BR><FONT face=3Dr_ansi=20
=
size=3D2> &nbs=
p; ON=20
CALCULATION ERRORS=20
=
REPORT &=
nbsp; &n=
bsp; &nb=
sp;=20
&</FONT> <BR><FONT face=3Dr_ansi=20
=
size=3D2> &nbs=
p; ON=20
EDIT ERRORS REPORT</FONT> <BR><FONT face=3Dr_ansi size=3D2>SET LOCK =
FILE=20
UPDATE</FONT> <BR><FONT face=3Dr_ansi size=3D2>ACC *FROMPOLF LINK TO =
POLICY-MASTER=20
LINK TO RENEW-POL-MASTER OPT</FONT> </P>
<P><FONT face=3Dr_ansi size=3D2>OUT POLICY-MASTER UPD ON ERRORS =
REPORT</FONT>=20
<FONT face=3Dr_ansi size=3D2>&</FONT> <BR><FONT face=3Dr_ansi =
size=3D2> ITEM=20
P-VEH-VIN-NUMBER(1) FINAL VIN IF =
P-VEH-VIN-NUMBER(1) =3D=20
VINTO ELSE &</FONT> <BR><FONT face=3Dr_ansi=20
size=3D2> =
P-VEH-VIN-NUMBER(1)</FONT>=20
<BR><FONT face=3Dr_ansi size=3D2> ITEM P-VEH-VIN-NUMBER(2) FINAL =
VIN IF P-VEH-VIN-NUMBER(2) =3D VINTO ELSE =
&</FONT>=20
<BR><FONT face=3Dr_ansi size=3D2> =20
P-VEH-VIN-NUMBER(2)</FONT> <BR><FONT face=3Dr_ansi size=3D2> =
ITEM=20
P-VEH-VIN-NUMBER(3) FINAL VIN IF =
P-VEH-VIN-NUMBER(3) =3D=20
VINTO ELSE &</FONT> <BR><FONT face=3Dr_ansi=20
size=3D2> =
P-VEH-VIN-NUMBER(3)</FONT>=20
<BR><FONT face=3Dr_ansi size=3D2> ITEM P-VEH-VIN-NUMBER(4) FINAL =
VIN IF P-VEH-VIN-NUMBER(4) =3D VINTO ELSE =
&</FONT>=20
<BR><FONT face=3Dr_ansi size=3D2> =20
P-VEH-VIN-NUMBER(4)</FONT> <BR><FONT face=3Dr_ansi size=3D2> =
ITEM=20
P-VEH-VIN-NUMBER(5) FINAL VIN IF =
P-VEH-VIN-NUMBER(5) =3D=20
VINTO ELSE &</FONT> <BR><FONT face=3Dr_ansi=20
size=3D2> =
P-VEH-VIN-NUMBER(5)</FONT>=20
<BR><FONT face=3Dr_ansi size=3D2> ITEM P-VEH-VIN-NUMBER(6) FINAL =
VIN IF P-VEH-VIN-NUMBER(6) =3D VINTO ELSE =
&</FONT>=20
<BR><FONT face=3Dr_ansi size=3D2> =20
P-VEH-VIN-NUMBER(6)</FONT> </P><BR><BR>
<P><FONT face=3Dr_ansi size=3D2>POLICY-NO =20
=
VIN &nbs=
p; =20
VINTO</FONT> </P>
<P><FONT face=3Dr_ansi size=3D2> =
1000173 =20
1B3BE46KXHC289815 1B3BBE46KYXH89815</FONT> <BR><FONT =
face=3Dr_ansi=20
size=3D2> 1000377 =
1P3XP24D9NN190832 =20
1P3X924D9NN190832</FONT> <BR><FONT face=3Dr_ansi =
size=3D2> =20
1000576 1G2AF54T9L6202569 =
1G2AF54T926202569</FONT>=20
<BR><FONT face=3Dr_ansi size=3D2> =
1000695 =20
1P3BP36D1HF143256 1P3PB36D1HF143236</FONT> <BR><FONT =
face=3Dr_ansi=20
size=3D2> 1001335 =
2FTJW36L5ECA90915 =20
2FTJW365ELA90915</FONT> <BR><FONT face=3Dr_ansi =
size=3D2> =20
1001437 1GBFG15R6T1020579 =
1GBFG15R6T1020597</FONT>=20
<BR><FONT face=3Dr_ansi size=3D2> </FONT> <FONT =
face=3Dr_ansi=20
size=3D2>1001618</FONT><FONT face=3Dr_ansi size=3D2> =
1B3BE46D2FC201855 1B3BE462DFC201855</FONT> <BR><FONT =
face=3Dr_ansi=20
size=3D2> </FONT> <FONT face=3Dr_ansi =
size=3D2>1001618</FONT><FONT=20
face=3Dr_ansi size=3D2> 1G1BN53E0NR118754 =20
1G1BN530NR118754</FONT> <BR><FONT face=3Dr_ansi =
size=3D2> =20
1002565 1C3BF66P4HX793597 =
1C38F66P4HX793597</FONT>=20
<BR><FONT face=3Dr_ansi size=3D2> =
1004476 =20
1G3HY54C8L1807541 IG3HY54C8L1807541</FONT> <BR><FONT =
face=3Dr_ansi=20
size=3D2> 1004654 =
1C3CJ51K1JG366618 =20
1C3CJ51K1JG36661B</FONT> <BR><FONT face=3Dr_ansi =
size=3D2> =20
1004693 SAJHX6247WC815550 =
SAJHK6247WC815550</FONT>=20
<BR><FONT face=3Dr_ansi size=3D2> =
1004969 =20
1FTHF25Y3GKA72854 1FTHF25Y36KA72854</FONT> <BR><FONT =
face=3Dr_ansi=20
size=3D2> 1005177 =
1B3XA46K3PF543136 =20
183XA46K3PF543136</FONT> <BR><FONT face=3Dr_ansi =
size=3D2> =20
1005335 WDBCB20A8DB049998 =
WDBCB20A8D049998</FONT>=20
<BR><FONT face=3Dr_ansi size=3D2> =
1005522 =20
1FALP52U3SA273426 1FLAP52U3SA273426</FONT> <BR><FONT =
face=3Dr_ansi=20
size=3D2> 1005527 =
1B7GN14M1HS423074 =20
1876N14M1H5423074</FONT> <BR><FONT face=3Dr_ansi =
size=3D2> =20
1005635 1G1ND52J5Y6273384 =
161ND52J5Y6273384</FONT>=20
<BR><FONT face=3Dr_ansi size=3D2> =
1005772 =20
1B3EJ46X9VN656093 AB3EJ46X9VN656093</FONT> =
</P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_006C_01C08563.1B88CAA0--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.