Subfile manipulation from within Quick

[Bert Onderdijk]

Dear Jeroen,
 
1. Although I don't exactly know how you declared the subfile in Quick,
you may have declared it as type designer. 
Since it's a non relational file I would use the additional close
specification like:
FILE SUBBESTAND
DESIGNER &
CLOSE 

2. If that won't do the job I would create a a specific transaction for
this subfile like:
TRANSACTION TR_SUBBESTAND &
READ WRITE &
READ COMMITTED 

And describe the designer like this:
FILE SUBBESTAND
DESIGNER &
CLOSE &
TRANSACTION TR_SUBBESTAND
 
And in the POSTUPDATE procedure
PROCEDURE POSTUPDATE
BEGIN
  COMMIT TR_SUBBESTAND
END
 
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.
The transaction will automatically be activated once you do a find.
 
Regards,
 
Bert
 
 
Bert Onderdijk
Piramide Operations 
<mailto:powerh-l at lists.sowder.com> 

________________________________

Van: powerh-l-bounces+b.onderdijk=piramide.nl at lists.sowder.com
[mailto:powerh-l-bounces+b.onderdijk=piramide.nl at lists.sowder.com]
Namens Jeroen van der Linde
Verzonden: maandag 8 december 2008 10:12
Aan: powerh-l at lists.sowder.com
Onderwerp: Subfile manipulation from within Quick


Hi all,
 
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.
 
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).
 
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. Can
anyone explain what happens here, or does anybody has a solution?
 
Regards,
Jeroen Vanderlinde
 
- Powerhouse 7.10G on OpenVMS V7.3-2 -
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20081208/77b04907/attachment.htm