Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
85 selects on a large database - looking for a way to si
Message
From
28/07/1999 12:00:22
Walter Meester
HoogkarspelNetherlands
 
 
To
28/07/1999 10:22:56
Dag Arneson
Cornell Univerity Hotel School
Ithaca, New York, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00247128
Message ID:
00247204
Views:
22
Dag,

What about:

SELECT computer.res_loc as nlabnum, HOUR(gdreportdate) as nHour, count(*) as cTally ;
FROM uselog INNER JOIN computer ON uselog.comp_id = computer.res_id
GROUP BY nLabnum, nHour ;
INTO CURSOR usage

and convert the cursor into the array afterwards ?

Walter,
Previous
Reply
Map
View

Click here to load this message in the networking platform