Subfile manipulation from within Quick

[Peter Bateman]

Hi Jeroen Have you tried the CLEAR option on the QUICK FILE statement? If that does not work    1)  I would create an FDL file for my subfile.sf file.       ANAL/RMS/FDL subfile.sf  ; check this command in the HP manuals    2) CLOSE subfile    3) RUN COMMAND "DELETE  subfile.sf;*"  ; delete data file    4) RUN COMMAND "CREATE/FDL=subfile.fdl" Regards,Peter  

Subject: RE: Subfile manipulation from within QuickDate: Mon, 8 Dec 2008 10:49:50 +0100From: b.onderdijk at piramide.nlTo: powerh-l at lists.sowder.comCC: J.vanderLinde at thegreenery.com
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 SUBBESTANDDESIGNER &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 SUBBESTANDDESIGNER &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 


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 LindeVerzonden: maandag 8 december 2008 10:12Aan: powerh-l at lists.sowder.comOnderwerp: 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 -
 

Win a trip with your 3 best buddies. Enter today.
_________________________________________________________________

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20081208/0dcdfd44/attachment-0001.htm