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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].