FP Support answers

[Richard Kreiss]

To all,

I appreciate that FP support responds in a very timely manner.

But, I take issue with their responses sometimes.  If one asks a specific question and it is not answered, although they may think the response covers it, the questioner may not find the response answering their question.

I received an error message during an output to too many files were open and filePro could only handle 60 files.  I asked if this could be increased and could I add a close to the lookups?  I recalled a long time ago that a lookup opened the key and data files as well as all of the screens and indexes.  At some point an auto close was added that closed the lookup without having to put an explicit close lookup alias file name in the processing. I am wondering if something has changed since that time back in the 1990's?

My second question was will a close lookup name work.

Supports comment was to add the system array allfiles the  only problem is that I would have to add this after each lookup in the processing table to see what is open at each point before the error message comes up.   Thisa does not directly answer my question "will a close lookup name work.  It may be easier to add a close to each lookup then figure out when to add popup showing all the files that are open. I can guess which lookup cause the most files to be opened and close those files which have the most screens and indexes associated with them.  I must keep in mind that auto processing does lookups also and those need to be closed also.


Richard Kreiss
GCC Consulting



-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 15595 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20210519/0fb42587/attachment.bin>