You may be better off with a cursor, 2gb limit.

Glenn

>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