<div dir="ltr">Richard,<div><br></div><div>Are you aware there is an online manual that will answer a lot of questions?</div><div><br></div><div>For your second question:</div><div><br></div><div><p style="margin:4pt 6.5pt 2.5pt 5.75pt;font-family:Arial;color:rgb(0,0,0)"><font color="#010100" face="Times New Roman" style="font-family:"Times New Roman";font-weight:bold">Syntax:</font></p><p style="margin:4pt 6.5pt 0pt 5.75pt;font-family:Arial;color:rgb(0,0,0)"><font color="#010100" face="Times New Roman" style="font-family:"Times New Roman""> Then: <font style="color:rgb(0,0,0);background-color:rgb(252,255,0)">close</font><br> Then: <font style="color:rgb(0,0,0);background-color:rgb(252,255,0)">close</font> filename</font></p><p style="margin:4pt 6.5pt 0pt 5.75pt;font-family:Arial;color:rgb(0,0,0)"><font color="#010100" face="Times New Roman" style="font-family:"Times New Roman"">Use <font style="color:rgb(0,0,0);background-color:rgb(252,255,0)">CLOSE</font> by itself to <font style="color:rgb(0,0,0);background-color:rgb(252,255,0)">close</font> all files except the current file.</font></p><p style="margin:4pt 6.5pt 0pt 5.75pt;font-family:Arial;color:rgb(0,0,0)"><font color="#010100" face="Times New Roman" style="font-family:"Times New Roman"">Use <font style="color:rgb(0,0,0);background-color:rgb(252,255,0)">CLOSE</font> filename to <font style="color:rgb(0,0,0);background-color:rgb(252,255,0)">close</font> an individual file, where "filename" is a lookup file name, or an export file name. <font style="color:rgb(0,0,0);background-color:rgb(252,255,0)">CLOSE</font> can be used on all processing tables.</font></p><p style="margin:4pt 6.5pt 0pt 5.75pt;font-family:Arial;color:rgb(0,0,0)"><font color="#010100" face="Times New Roman" style="font-family:"Times New Roman""><br></font></p><p style="margin:4pt 6.5pt 0pt 5.75pt;color:rgb(0,0,0)"><font color="#010100" style="" face="arial, sans-serif">As for your first question, I think the suggestion to use the system array to see what files are open was a good suggestion as it will either confirm or deny your suspicions that "all of the screens" get opened. I don't think that is correct. From what you have stated we must assume, and that is never a good thing, that you are using [dr]clerk and input processing since your mentioned screens. I believe filePro will open auto, input, key, data, all indexes and the current screen of the input table and then key, data and the index being used for each lookup. That may be all indexes but hey the file array would tell us 100% without guessing!</font></p><p style="margin:4pt 6.5pt 0pt 5.75pt;color:rgb(0,0,0)"><br></p><p style="margin:4pt 6.5pt 0pt 5.75pt;color:rgb(0,0,0)">You are correct about there being an "auto close" feature at some time.</p><p style="margin:4pt 6.5pt 0pt 5.75pt;color:rgb(0,0,0)"><br></p><p style="margin:4pt 6.5pt 0pt 5.75pt;color:rgb(0,0,0)">If you had read the online manual for System Arrays you would have found this</p><p style="margin:4pt 6.5pt 0pt 5.75pt;color:rgb(0,0,0)"><span style="font-family:"Times New Roman";font-weight:bold;color:rgb(1,1,0)"><br></span></p><p style="margin:4pt 6.5pt 0pt 5.75pt;color:rgb(0,0,0)"><span style="font-family:"Times New Roman";font-weight:bold;color:rgb(1,1,0)">@ALLFILES[]</span></p><p style="margin:4pt 6.5pt 0pt 5.75pt;color:rgb(0,0,0)"><span style="font-family:"Times New Roman";color:rgb(1,1,0)">Contains a list of all files open by filePro, even those </span><font style="font-family:"Times New Roman";background-color:rgb(252,255,0)">closed</font><span style="font-family:"Times New Roman";color:rgb(1,1,0)"> </span><span style="font-family:"Times New Roman";color:rgb(1,1,0)">due to dynamic open/</span><font style="font-family:"Times New Roman";background-color:rgb(252,255,0)">close</font><span style="font-family:"Times New Roman";color:rgb(1,1,0)">. Some entries may be blank, representing an unused (i.e.</span><span style="font-family:"Times New Roman";color:rgb(1,1,0)"> </span><font style="font-family:"Times New Roman";background-color:rgb(252,255,0)">closed</font><span style="font-family:"Times New Roman";color:rgb(1,1,0)">) file.</span></p><p style="margin:4pt 6.5pt 0pt 5.75pt;color:rgb(0,0,0)"><br></p><p style="margin:4pt 6.5pt 0pt 5.75pt;color:rgb(0,0,0)">I hope that helps, don't forget the old programmers adage RT[F]M :-)</p><p style="margin:4pt 6.5pt 0pt 5.75pt;color:rgb(0,0,0)"><br>Regards</p><p style="margin:4pt 6.5pt 0pt 5.75pt;color:rgb(0,0,0)"><br></p><p style="margin:4pt 6.5pt 0pt 5.75pt;color:rgb(0,0,0)">Ken</p></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, 20 May 2021 at 02:27, Richard Kreiss via Filepro-list <<a href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">To all,<br>
<br>
I appreciate that FP support responds in a very timely manner.<br>
<br>
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.<br>
<br>
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?<br>
<br>
My second question was will a close lookup name work.<br>
<br>
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.<br>
<br>
<br>
Richard Kreiss<br>
GCC Consulting<br>
<br>
<br>
<br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: winmail.dat<br>
Type: application/ms-tnef<br>
Size: 15595 bytes<br>
Desc: not available<br>
URL: <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20210519/0fb42587/attachment.bin" rel="noreferrer" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20210519/0fb42587/attachment.bin</a>><br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote></div>