<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16735" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff><SPAN
class=779473709-08122008>Dear Jeroen,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff><SPAN
class=779473709-08122008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff><SPAN
class=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=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=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=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=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=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=779473709-08122008><SPAN class=779473709-08122008>FILE
SUBBESTAND<BR>DESIGNER &<BR>CLOSE &<BR>TRANSACTION
TR_SUBBESTAND</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=779473709-08122008><SPAN
class=779473709-08122008></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=779473709-08122008><SPAN
class=779473709-08122008>And in the POSTUPDATE
procedure</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=779473709-08122008><SPAN
class=779473709-08122008>PROCEDURE POSTUPDATE</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=779473709-08122008><SPAN
class=779473709-08122008>BEGIN</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=779473709-08122008><SPAN
class=779473709-08122008> COMMIT TR_SUBBESTAND</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=779473709-08122008><SPAN
class=779473709-08122008>END</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=779473709-08122008><SPAN
class=779473709-08122008></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=779473709-08122008><SPAN
class=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=779473709-08122008><SPAN
class=779473709-08122008></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=779473709-08122008><SPAN
class=779473709-08122008>Regards,</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=779473709-08122008><SPAN
class=779473709-08122008></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=779473709-08122008><SPAN
class=779473709-08122008>Bert</SPAN></SPAN></FONT></DIV>
<DIV><FONT><SPAN class=779473709-08122008><SPAN
class=779473709-08122008> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=779473709-08122008></SPAN><FONT face=Arial
color=#0000ff size=2>B<SPAN class=779473709-08122008>ert
Onderdijk</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT><SPAN class=779473709-08122008></SPAN><SPAN
class=779473709-08122008></SPAN><FONT face=Arial color=#0000ff size=2>P<SPAN
class=779473709-08122008>iramide Operations
</SPAN></FONT></FONT></SPAN></SPAN></FONT><FONT face=Arial color=#0000ff
size=2><SPAN class=779473709-08122008></DIV><A
href="mailto:powerh-l@lists.sowder.com"></A></SPAN></FONT><BR>
<DIV class=OutlookMessageHeader lang=nl dir=ltr align=left>
<HR tabIndex=-1>
<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=398475208-08122008><FONT face=Arial size=2>Hi
all,</FONT></SPAN></DIV>
<DIV><SPAN class=398475208-08122008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=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=398475208-08122008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=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=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=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=398475208-08122008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=398475208-08122008><FONT face=Arial
size=2>Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=398475208-08122008><FONT face=Arial size=2>Jeroen
Vanderlinde</FONT></SPAN></DIV>
<DIV><SPAN class=398475208-08122008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=398475208-08122008><FONT face=Arial size=2>- Powerhouse 7.10G
on OpenVMS V7.3-2 -</FONT></SPAN></DIV>
<DIV><SPAN class=398475208-08122008><FONT face=Arial
size=2></FONT></SPAN> </DIV></BODY></HTML>