Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Array is Bonkers
Message
De
09/02/2004 12:36:09
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
SQL Array is Bonkers
Divers
Thread ID:
00875521
Message ID:
00875521
Vues:
66
This is Bonkers....

Using VFP 8 SP1:

I'm executing a simple SQL query and attempting to store it in an array, thus:

SELECT jobs.JobName, jobs.JobID FROM JOBS ;
WHERE GROUPID = "GRP10000009" ;
INTO ARRAY jArray

VFP immediately pukes with: "JARRAY is not an Array"

From VFP Help:
"To send SELECT - SQL query results to an array, specify the INTO ARRAY clause with an array name. If the array doesn't exist, it is automatically created. If the array does exist, it is redimensioned automatically to accommodate the query results."

If I pre-dimension the array it works....if I don't it barfs...
If I pre-dimension the array it will only hold as many elements as I've dimensioned it for... it won't redimension automatically.

Is this a bug, have I overlooked some 'switch', or should I be looking for
a job as a Wal_Mart Greeter?

Thanks for not laughing....(too hard)

David
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform