Thanks Tracy, I did indeed just find System Capacities listed under General Ref within the Online help. And, thanks for confirming what I kinda figured - that the error was related to the large number of work areas currently in use when this program crashed. Yesterday - I was staying within the system to process Multiple Large batches of Data loads. Each Load would literally take an hour or more to process. Going forwards - from now on I will ONLY process a Single large batch at a time - then Exit the system and start it back up again before processing another large batch load. I'm sure that will help avoid this particular problem.
Thanks again, Kurt -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Tracy Pearson Sent: Friday, May 15, 2015 11:01 AM To: [email protected] Subject: RE: Table number is invalid Kurt Wendt wrote on 2015-05-15: > I got this error yesterday. I tried to do a search on the Web for > this error, but, some of the webpages seem to be Blocked - while one page I got a 404 error. > > The system I am working on - when it threw the error - it did a > Memory Dump. What I found was curious - was that it shows that a Select Area of 35861. I'm literally looking at a display of Thousands of Temp files open in Thousands of Work Areas. This system seems to be rather bad in not closing out Temp files. > > I did find a Cached version of a webpage by Jim Booth that claims VFP > has 32,767 available work area - which is smaller than the # I show above. > > So - the error in the Subject - could it simply be that I the program reached the Max # of Files or Max # of Work Areas that can be open in VFP at once? > > Thanks, > Kurt Wendt > Consultant > Kurt, In the Visual FoxPro 9.0 help file under the "Visual FoxPro System Capacities", it shows Maximum # of tables open at one time is 65,535. Table number is invalid, appears to happen with the "SELECT" command when the number is greater than 32,767. It also happens when one tries: USE {table} IN 32768 Maximum # of tables open at one time, may be referring to multiple data sessions. I'm not going to test that today. The program may have an invalid #, when attempting to switch back to the cursor that was active when beginning the function that failed. Tracy Pearson PowerChurch Software [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f1b7...@drexch02.corp.globetax.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
