Retrieving and displaying records by non-indexed fields on Quickscreens

[Joe Boyle]

and multiple retrieval paths can be coded for as many indexes as you have 
decided to include in your subfile.

regards joe.

----- Original Message ----- 
From: <roger32909 at bellsouth.net>
To: <powerh-l at lists.sowder.com>
Sent: Sunday, July 17, 2005 4:07 AM
Subject: Retrieving and displaying records by non-indexed fields on 
Quickscreens


> Restrictions:  PH 7.10G on OpenVMS with no relational database, only RMS 
> files.  The project manager declined request for additional indexes.
>
> The requirement is to allow user to retrieve and display records by at 
> least 5 fields.  Three are indexed and can be handled by normal ACCESS 
> statements with default PATHs & FINDs.  But the fourth is a date range and 
> the fifth is a non-indexed field.
> The primary file will occur 15 times and the user may drill down by using 
> a designer procedure 01 to run a screen displaying more details.
>
> This system already has 2 screens with multiple prompts and a convoluted 
> SELECT statement, custom PATH & FIND procedures to handle screen displays 
> of data retrieved on non-indexed fields.  Of course there is no 
> sort/order, but it works.  A new screen is supposed to follow this 
> pattern.  But I wonder if there may be a simpler solution.
>
> For example, I have seen (and used) permanent indexed subfiles (re-filled 
> by QTP or QUIZ) to sort & display records on QUICK screens retrieved on 
> non-indexed fields. The tradeoff is a slight delay for the QTP/QUIZ run.
>
> I have not tried, but assume one could also declare several versions of 
> the same file using aliases with ACCESS/SELECT statements and passing the 
> retrieved data to occurring TEMPs for screen display.
>
> Would like to hear of other possible solutions to similar requirements.
>
> -- 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: "subscribe" in message body to 
> powerh-l-request at lists.sowder.com
> Unsubscribe: "unsubscribe &lt;password&gt;" in message body to 
> powerh-l-request at lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
>