Subfile manipulation from within Quick

[Peter Bateman]

Hi Jeroen:
 
    Re-thinking this problem. It seems to me that QTP has not cleared your subfile.
    So the steps outlined below should work but you need to create the empty subfile 
    before running your QTP process.
 
     1) Do this step once after running QTP
         Create an FDL file forsubfile.sf file.          ANAL/RMS/FDL subfile.sf  ; check this command in the HP manuals
   Do the following before running QTP   2) CLOSE subfile    3) RUN COMMAND "DELETE/ERASE  subfile.sf;*"  ; delete data file(s)    4) RUN COMMAND "CREATE/FDL=subfile.fdl"
 
   5) RUN COMMAND "QTP etc"
 
Regards,
Peter
 
    




From: peterbateman808 at hotmail.comTo: b.onderdijk at piramide.nl; powerh-l at lists.sowder.comSubject: RE: Subfile manipulation from within QuickDate: Mon, 8 Dec 2008 15:01:32 -0400

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.

Visit messengerbuddies.ca to find out how you could win. Enter today.
_________________________________________________________________

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20081210/bfcdc0c4/attachment.htm