General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>>Hi
>>>>>
>>>>>Using VFP8.
>>>>>Select into array can only accept 24 columns. is that right?
>>>>>
>>>>>I am getting "too many variables" error when I select more than 24 column into the array.
>>>>>is there awork around it?
>>>>>
>>>>>Mo
>>>>
>>>>Arrays are limited to approximately 16k of elements. The problem is not the number of columns, but the number of rows. How many records are being selected?
>>>
>>>It's 65,000 elements, not 16K. This restriction has been entirely lifted in VFP9.
>>>
>>
>>VFP9 array size is bounded to 67M = 2^(30-4)
>
>Well of course there is an actual limit. Just not one that I think any kind of "currently" reasonable code would ever encounter. That may very well change in the future.
>
>And are you sure of your upper limit? I thought it was limited by available memory. I couldn't make an array of 50M (2x25,000,000)elements as I had insufficient memory on a machine with 512MB, but I usually have many apps currently running.
Fred, i don't say that i can allocate a 67M array,
a say that this is a VFP9 bound, indipendently by the available memory.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only