Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>>>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement