<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_398475208-08122008><FONT face=Arial size=2>Jeroen</FONT></SPAN><BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial>Have you tried the CLEAR option on the QUICK FILE statement?</FONT></SPAN><BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial>If that does not work</FONT></SPAN><BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial> 1) </FONT></SPAN><SPAN class=EC_398475208-08122008><FONT face=Arial>I would create an FDL file for my subfile.sf file.</FONT></SPAN><BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial> ANAL/RMS/FDL subfile.sf ; check this command in the HP manuals</FONT></SPAN><BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial> 2) CLOSE subfile</FONT></SPAN><BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial> </FONT></SPAN><BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial> 3) RUN COMMAND "DELETE subfile.sf;*" ; delete data file</FONT></SPAN><BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial> 4) RUN COMMAND "CREATE/FDL=subfile.fdl"</FONT></SPAN><BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial>Regards,</FONT></SPAN><BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial>Peter</FONT></SPAN><BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR>
<SPAN class=EC_398475208-08122008><FONT face=Arial></FONT></SPAN> <BR>
<BR><BR><BR>
<HR id=stopSpelling>
<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>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff><SPAN class=EC_779473709-08122008>Dear Jeroen,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff><SPAN class=EC_779473709-08122008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff><SPAN class=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_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_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_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_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_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_779473709-08122008><SPAN class=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_779473709-08122008><SPAN class=EC_779473709-08122008></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=EC_779473709-08122008><SPAN class=EC_779473709-08122008>And in the POSTUPDATE procedure</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=EC_779473709-08122008><SPAN class=EC_779473709-08122008>PROCEDURE POSTUPDATE</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=EC_779473709-08122008><SPAN class=EC_779473709-08122008>BEGIN</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=EC_779473709-08122008><SPAN class=EC_779473709-08122008> COMMIT TR_SUBBESTAND</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=EC_779473709-08122008><SPAN class=EC_779473709-08122008>END</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=EC_779473709-08122008><SPAN class=EC_779473709-08122008></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=EC_779473709-08122008><SPAN class=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_779473709-08122008><SPAN class=EC_779473709-08122008></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=EC_779473709-08122008><SPAN class=EC_779473709-08122008>Regards,</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=EC_779473709-08122008><SPAN class=EC_779473709-08122008></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=EC_779473709-08122008><SPAN class=EC_779473709-08122008>Bert</SPAN></SPAN></FONT></DIV>
<DIV><SPAN class=EC_779473709-08122008><SPAN class=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_779473709-08122008></SPAN><FONT face=Arial color=#0000ff size=2>B<SPAN class=EC_779473709-08122008>ert Onderdijk</SPAN></FONT></DIV>
<DIV dir=ltr align=left><SPAN class=EC_779473709-08122008></SPAN><SPAN class=EC_779473709-08122008></SPAN><FONT face=Arial color=#0000ff size=2>P<SPAN class=EC_779473709-08122008>iramide Operations </SPAN></FONT></SPAN></SPAN></FONT><FONT face=Arial color=#0000ff size=2><SPAN class=EC_779473709-08122008></DIV><A href="mailto:powerh-l@lists.sowder.com"></A></SPAN></FONT><BR>
<DIV class=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_398475208-08122008><FONT face=Arial size=2>Hi all,</FONT></SPAN></DIV>
<DIV><SPAN class=EC_398475208-08122008><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=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_398475208-08122008><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=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_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_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_398475208-08122008><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=EC_398475208-08122008><FONT face=Arial size=2>Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=EC_398475208-08122008><FONT face=Arial size=2>Jeroen Vanderlinde</FONT></SPAN></DIV>
<DIV><SPAN class=EC_398475208-08122008><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=EC_398475208-08122008><FONT face=Arial size=2>- Powerhouse 7.10G on OpenVMS V7.3-2 -</FONT></SPAN></DIV>
<DIV><SPAN class=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' target='_new'>Enter today.</a></body>
</html>