Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Array is Bonkers
Message
From
09/02/2004 12:39:05
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
09/02/2004 12:36:09
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00875521
Message ID:
00875524
Views:
17
>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

What's a bonker I don't know.

If there are no records matching the query then the array wouldn't be created. Check _tally before attempting to use jArray.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform