RE: 4 - subfiles

[Chris Bipes <rpg@xxxxxxxxxxxxxxx>]

Define four subfiles. One for each LF and put the sort field, (key to the
logical file), in the first column.  Now you load if it is the first time
displayed or just re-display if already loaded.
 
Christopher K. Bipes     mailto:ChrisB@Cross-Check.com
<mailto:ChrisB@Cross-Check.com>  
Sr. Programmer/Analyst   mailto:Chris_Bipes@Yahoo.com
<mailto:Chris_Bipes@Yahoo.com>  
CrossCheck, Inc.         http://www.cross-check.com
<http://www.cross-check.com/>  
6119 State Farm Drive    Phone: 707 586-0551 x 1102 
Rohnert Park CA  94928 Fax: 707 586-1884 

*Note to Recruiters 
Neither I, nor anyone that I know of, is interested in any new and/or
exciting positions. Please do not contact me. 

-----Original Message-----
From: boothm@earth.goddard.edu [mailto:boothm@earth.goddard.edu]
Sent: Wednesday, November 03, 1999 6:09 PM
To: midrange-l@midrange.com
Subject: 4 - subfiles



Here's a subfile question.  I'm not very good with them.  I have a display
screen showing a subfile with 4 fields.  Each field is the key to a logical
file so there are 4 logical files in the F-specs.  For clarity, lets call
the fields LastName, FirstName, ExtNbr, DeptName.  I want the user to be
able to display any one of the 4 logical files.  I know the file will never
grow beyond 999 because the ExtNbr field is 3/0, and because there's only
about 150 extensions now, anyway.   Every time the user selects another
logical to display I clear the subfile and  reload the entire file to the
subfile.  With a dozen test records I'm getting sub-second reloads.  Now, as
the number of records increases it seems to me that reload times will
increase.  Still, I know that 5000 records load in 11 or 12 seconds so the
time for about 200 records will probably be a second or two. 

However, it occurs to me that having loaded the subfile, I shouldn't need to
read the data file again.  I am thinking there must be an easy way to save
the subfile in case it is needed again, instead of just clearing it, or am I
tilting at windmills?

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---