Hi Erik,

It's MVCOUNT, actually (you were soooo close).

And an array only occupies 1 in that count, regardless of the dimension.

Cheers,

Jim N

>>I get this error when trying to run the Stonefield Database Toolkit for the first time against my Mere Mortals database. The error occurs when trying to validate the USERS table. Any explanations?
>>
>>SDT version:
>>Error #: 22
>>Message: Too many variables.
>>Line #: 77
>>Code: dimension taFieldList[lnTableFields, 6]
>>Method: GETDBFSTRUCTURE
>>Object: frmSDT.SDTDBCXMGR.OSDTMGR
>
>Looks like lnTableFields got to be a pretty big number, or there are a lot of other arrays dimensioned as well. The default maximum for declared variables in VFP is 1024. You can change this, in the Config.fpw, I believe- and set it closer to the maximum allowable: 65,000. I apologize, but I can't for the life of me remember the setting- VARCOUNT or something. (Someone wanna jump in here?)
>
>
>I would alert Doug to this. I have had the same problem with ome of his code and had to raise my limit. While it is workable, I would think a more desirable solution would be to be more careful with how many large arrays are in existence at any given time.