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
_______________________________________________
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/[email protected]
** 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.
