>>>I tried to use the search in the VFP help, but could not fund the required topic. Perhaps I did not use the right keywords. The advantages of printed documentation is that one can quickly flip through pages to find the required information. Moreover, after some use, one starts getting a feel that such and such topic is in a particular section of the book, thus it becomes easier to find info.
>>
>>Type:
>>System capacities
>>in index.
>>PS: In practice unlimited (who would open hundreths of tables at a time).
>
>If anyone did that, we'd have a nice thread about it, and about problems it would create. While theoretically limited only by 32767, practically it'd be quickly limited with system's capacity. Each opened table takes resources, needs buffers, handles, etc - and having thousands of tables open simultaneously would surely bring the system to its knees really soon.
>
>Next thing you know, someone would ask "why are you doing this", and we'd have another trip to Kia via Saturn Diesel.

LOL! Oddly enough, I was involved with a system where instead of taking private data sessions, they went with everything in the default data session and generated unique names for the cursors based on the customer id.

This LIMITED them to only 32767 instead of 32767 x # of private data sessions, but it also opened up a terrible risk. If the wrong work area was selected customer A information would get cross with customer B information. That's not bad, but in this case it was a medical system and it would have killed someone had we not caught it during alpha testing.

Everything is possible without standards and that's not the good thing everyone seems to think it is.