>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