Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The REAL theoretical limit of opened tables of VFP6
Message
From
13/02/2000 17:16:43
 
 
To
13/02/2000 15:32:42
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00331559
Message ID:
00331582
Views:
13
>Dear All,
>
>I would like to know the TRUTH, about the limit of opened table in VFP.
>
>I read my MSDN CD and it states that 255. Ridicoluos.
>
>I saw VFP5 old help file. It shows 2551. (It is not typo, really two thousand fivehundredfiftyone.)
>
>So, I checked MS MSDN Online on net. It also states 255.
>
>Hmmm, as far as I tested, the limit is more than some thousands. I couldnot never reached the theoretical limit.
>
>Where is this limit documented correctly? And what is it?
>
>bb
>
>TIA

Try it your self using some code like:
FOR i = 1 TO 30000

	lcAlias = "MyTable" + ALLTRIM(STR(i))
	WAIT WINDOW lcAlias NOWAIT
	USE MyTable AGAIN IN 0 ALIAS (lcAlias)
ENDFOR
I let it get to 2700 before I got bored.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform