Quick & While Retrieving

[Chris Sharman]

Matthew Cox wrote:
> I'm new to Powerhouse and have a question regarding While Retieving in
> Quick. I have a screen that has a master record in the top half of the
> layout and a detail section being done with a cluster command on the bottom
> half. My problem is the cluster section displays 12 lines of information and
> a total field below the cluster. The total line is not adding in any detail
> records if the number of detail records is more than 12. Can I use While
> Retrieving to total the cost together for all the detail records being
> selected by the master record? Where do I put the While Retrieving loop? Any
> help is greatly appreciated

while retrieving is mainly for designer files.

You've presumably got "occurs 12" - have you got a "cache" or "cache 
255" or something too ?
This was introduced around 7.10 (depending on platform) to allow PH to 
read & handle more records than it displayed - up to a limit of 255.
You don't say what platform/version you've got.
If you can't use cache, then probably you do need a very clunky solution 
with extra designer files and while retrieving, but using cache in a 
newer version would be the much preferred route.

Any "FOR <detail>" code you have will continue to work, and there's "FOR 
DISPLAYED <detail>" should you want it.

Chris

Any views expressed in this message are those of the sender and not necessarily those of CCA Group.  The unauthorized use, disclosure, copying or alteration of this message is forbidden.  The contents of this message may be confidential and/or privileged, copyright CCA Group and are intended solely for the use of the individual or entity to whom they are addressed.  Whilst this message has been scanned, CCA Group cannot guarantee that it is virus free or compatible with your systems and accepts no responsibility for any loss or damage arising from its use. The recipient is advised to run their own anti-virus software. If you receive this message in error please contact postmaster at ccagroup.co.uk immediately, destroy any copies and delete it from your computer systems.