David,

You would get this error if jArray is already declared as a memory variable. You should declare jArray as array before you use it. The only time a SELECT-SQL doesn't change array size/contents is when it returns no records.

LOCAL ARRAY jArray[1]
SELECT jobs.JobName, jobs.JobID FROM JOBS ;
WHERE GROUPID = "GRP10000009" ;
INTO ARRAY jArray
IF _TALLY = 0
  * No records selected, jArray hasn't been changed
ENDIF

>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