<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
Hi <SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial size=2>Jeroen:</FONT></SPAN><BR>
<SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR>
<SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> Re-thinking this problem. It seems to me that QTP has not cleared your subfile.</FONT></SPAN><BR>
<SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> So the steps outlined below should work but you need to create the empty subfile </FONT></SPAN><BR>
<SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> before running your QTP process.</FONT></SPAN><BR>
<SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR>
<SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> <SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> 1) Do this step once after running QTP</FONT></SPAN></FONT></SPAN><BR>
<SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial><SPAN class=EC_EC_EC_398475208-08122008> Create </SPAN><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial>an FDL file forsubfile.sf file.</FONT></SPAN><BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial></FONT></SPAN><FONT face=Verdana> <BR></FONT><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> ANAL/RMS/FDL subfile.sf ; check this command in the HP manuals</FONT></SPAN></FONT></SPAN><BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial><SPAN class=EC_EC_EC_398475208-08122008></SPAN>
<BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial></FONT></SPAN><FONT face=Verdana> Do the following before running QTP<BR></FONT><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> 2) CLOSE subfile</FONT></SPAN><BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> </FONT></SPAN><BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> 3) RUN COMMAND "DELETE/ERASE subfile.sf;*" ; delete data file(s)</FONT></SPAN><BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial></FONT></SPAN><FONT face=Verdana> <BR></FONT><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> 4) RUN COMMAND "CREATE/FDL=subfile.fdl"</FONT></SPAN><BR>
<SPAN class=EC_EC_EC_398475208-08122008></SPAN> <BR>
<SPAN class=EC_EC_EC_398475208-08122008> 5) RUN COMMAND "QTP etc"</SPAN><BR>
<SPAN class=EC_EC_EC_398475208-08122008></SPAN> <BR>
<SPAN class=EC_EC_EC_398475208-08122008>Regards,</SPAN><BR>
<SPAN class=EC_EC_EC_398475208-08122008>Peter</SPAN></FONT></SPAN><BR>
<SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR>
<SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> </FONT></SPAN><BR>
<BR><BR><BR>
<HR id=stopSpelling>
<BR>
From: peterbateman808@hotmail.com<BR>To: b.onderdijk@piramide.nl; powerh-l@lists.sowder.com<BR>Subject: RE: Subfile manipulation from within Quick<BR>Date: Mon, 8 Dec 2008 15:01:32 -0400<BR><BR>
<STYLE>
.ExternalClass .EC_hmmessage P
{padding:0px;}
.ExternalClass body.EC_hmmessage
{font-size:10pt;font-family:Verdana;}
</STYLE>
Hi <SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial size=2>Jeroen</FONT></SPAN><BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial>Have you tried the CLEAR option on the QUICK FILE statement?</FONT></SPAN><BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial>If that does not work</FONT></SPAN><BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> 1) </FONT></SPAN><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial>I would create an FDL file for my subfile.sf file.</FONT></SPAN><BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> ANAL/RMS/FDL subfile.sf ; check this command in the HP manuals</FONT></SPAN><BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> 2) CLOSE subfile</FONT></SPAN><BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> </FONT></SPAN><BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> 3) RUN COMMAND "DELETE subfile.sf;*" ; delete data file</FONT></SPAN><BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial> 4) RUN COMMAND "CREATE/FDL=subfile.fdl"</FONT></SPAN><BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial>Regards,</FONT></SPAN><BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial>Peter</FONT></SPAN><BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR><BR><BR><BR><BR>
<HR id=EC_EC_stopSpelling>
<BR>
<BR>Subject: RE: Subfile manipulation from within Quick<BR>Date: Mon, 8 Dec 2008 10:49:50 +0100<BR>From: b.onderdijk@piramide.nl<BR>To: powerh-l@lists.sowder.com<BR>CC: J.vanderLinde@thegreenery.com<BR><BR><BR><BR>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff><SPAN class=EC_EC_EC_779473709-08122008>Dear Jeroen,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff><SPAN class=EC_EC_EC_779473709-08122008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff><SPAN class=EC_EC_EC_779473709-08122008>1. Although I don't exactly know how you declared the subfile in Quick, you may have declared it as type designer. </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff><SPAN class=EC_EC_EC_779473709-08122008>Since it's a non relational file I would use the additional close specification like:</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff><SPAN class=EC_EC_EC_779473709-08122008><FONT size=2>FILE SUBBESTAND<BR>DESIGNER &<BR>CLOSE</FONT> <BR></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff><SPAN class=EC_EC_EC_779473709-08122008>2. If that won't do the job I would create a a specific transaction for this subfile like:</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff><SPAN class=EC_EC_EC_779473709-08122008><FONT size=2>TRANSACTION TR_SUBBESTAND &<BR>READ WRITE &<BR>READ COMMITTED</FONT> <BR></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff><SPAN class=EC_EC_EC_779473709-08122008>And describe the designer like this:</DIV></SPAN></FONT>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN class=EC_EC_EC_779473709-08122008><SPAN class=EC_EC_EC_779473709-08122008>FILE SUBBESTAND<BR>DESIGNER &<BR>CLOSE &<BR>TRANSACTION TR_SUBBESTAND</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=EC_EC_EC_779473709-08122008><SPAN class=EC_EC_EC_779473709-08122008></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=EC_EC_EC_779473709-08122008><SPAN class=EC_EC_EC_779473709-08122008>And in the POSTUPDATE procedure</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=EC_EC_EC_779473709-08122008><SPAN class=EC_EC_EC_779473709-08122008>PROCEDURE POSTUPDATE</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=EC_EC_EC_779473709-08122008><SPAN class=EC_EC_EC_779473709-08122008>BEGIN</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=EC_EC_EC_779473709-08122008><SPAN class=EC_EC_EC_779473709-08122008> COMMIT TR_SUBBESTAND</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=EC_EC_EC_779473709-08122008><SPAN class=EC_EC_EC_779473709-08122008>END</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=EC_EC_EC_779473709-08122008><SPAN class=EC_EC_EC_779473709-08122008></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=EC_EC_EC_779473709-08122008><SPAN class=EC_EC_EC_779473709-08122008>Option 2 will explicitely close the once opened subfile and it's file open transaction meaning that any new access of that (sub)file will do a physical reread.<BR>The transaction will automatically be activated once you do a find.</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=EC_EC_EC_779473709-08122008><SPAN class=EC_EC_EC_779473709-08122008></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=EC_EC_EC_779473709-08122008><SPAN class=EC_EC_EC_779473709-08122008>Regards,</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=EC_EC_EC_779473709-08122008><SPAN class=EC_EC_EC_779473709-08122008></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=EC_EC_EC_779473709-08122008><SPAN class=EC_EC_EC_779473709-08122008>Bert</SPAN></SPAN></FONT></DIV>
<DIV><SPAN class=EC_EC_EC_779473709-08122008><SPAN class=EC_EC_EC_779473709-08122008> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2> </DIV>
<DIV dir=ltr align=left><SPAN class=EC_EC_EC_779473709-08122008></SPAN><FONT face=Arial color=#0000ff size=2>B<SPAN class=EC_EC_EC_779473709-08122008>ert Onderdijk</SPAN></FONT></DIV>
<DIV dir=ltr align=left><SPAN class=EC_EC_EC_779473709-08122008></SPAN><SPAN class=EC_EC_EC_779473709-08122008></SPAN><FONT face=Arial color=#0000ff size=2>P<SPAN class=EC_EC_EC_779473709-08122008>iramide Operations </SPAN></FONT></SPAN></SPAN></FONT><FONT face=Arial color=#0000ff size=2><SPAN class=EC_EC_EC_779473709-08122008></DIV><A href="mailto:powerh-l@lists.sowder.com"></A></SPAN></FONT><BR>
<DIV class=EC_EC_EC_OutlookMessageHeader lang=nl dir=ltr align=left>
<HR>
<FONT face=Tahoma size=2><B>Van:</B> powerh-l-bounces+b.onderdijk=piramide.nl@lists.sowder.com [mailto:powerh-l-bounces+b.onderdijk=piramide.nl@lists.sowder.com] <B>Namens </B>Jeroen van der Linde<BR><B>Verzonden:</B> maandag 8 december 2008 10:12<BR><B>Aan:</B> powerh-l@lists.sowder.com<BR><B>Onderwerp:</B> Subfile manipulation from within Quick<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial size=2>Hi all,</FONT></SPAN></DIV>
<DIV><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial size=2>I am trying to manipulate a subfile from within a Quick screen. The subfile doesn't exist when I enter the Quick screen (.SFD does exists). In the Postpath-procedure the subfile is generated using QTP and filled with the desired data (lets say QTP finds and ads 100 records). So far so good, no problem here.</FONT></SPAN></DIV>
<DIV><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial size=2>When I try to fill the subfile with new data (do a new find from within Quick, so the Postpath refills the subfile) and retrieve the generated records (lets say 50 records), I still see the records from my previous find (the 100 records), despite of the subfile being filled with the correct records (50 record, checked with another session).</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial size=2>I can't really explains what happens here. It seems to me that it has something to do with Quick's initialisation of record-buffers. </FONT></SPAN><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial size=2>Can anyone explain what happens here, or does anybody has a solution?</FONT></SPAN></DIV>
<DIV><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial size=2>Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial size=2>Jeroen Vanderlinde</FONT></SPAN></DIV>
<DIV><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial size=2>- Powerhouse 7.10G on OpenVMS V7.3-2 -</FONT></SPAN></DIV>
<DIV><SPAN class=EC_EC_EC_398475208-08122008><FONT face=Arial size=2></FONT></SPAN> </DIV><BR>
<HR>
Win a trip with your 3 best buddies. <A href="http://www.messengerbuddies.ca/?ocid=BUDDYOMATICENCA19">Enter today.</A><BR>
<HR>
Visit messengerbuddies.ca to find out how you could win. <A href="http://www.messengerbuddies.ca/?ocid=BUDDYOMATICENCA20">Enter today.</A><br /><hr />Win a trip with your 3 best buddies. <a href='http://www.messengerbuddies.ca/?ocid=BUDDYOMATICENCA19' target='_new'>Enter today.</a></body>
</html>