If you can use a cursor instead of an array you will be much better off.
The cursor will be faster and has a much larger capacity limit...

>I have a program that reads a table and stores the result set in an array using the select ... into array command. That table is roughly 50000 x 10. I get VFP error 22, Too many variables. I am using VFP 7.0 SP1. This program is part of a larger architecture where data is being passed by array. Is there any way for VFP to handle a large array or is this a product limitation? Any help would be appreciated.
>
>Tom Paterno