Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crosstab giving errors
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Crosstab giving errors
Miscellaneous
Thread ID:
00088488
Message ID:
00088488
Views:
68
VFP 3.0b for Windows.

When I run the following crosstab it works find from an APP file but crashed when run from an EXE file. The error is "File dcounts1.dbf does not exist"

Could anyone tell me what I am doing wrong...

SELECT dtoc(diallog.rundate) + " " + diallog.dialtime as shift,;
Diallog.dial_loc, COUNT(Diallog.dial_type);
FROM diallog;
WHERE Diallog.dial_type = thetype and;
Diallog.rundate >= statbeg and;
Diallog.rundate <= statend;
GROUP BY 1, Diallog.dial_loc;
ORDER BY 1, Diallog.dial_loc;
INTO CURSOR dcounts1
select dcounts1
DO (_GENXTAB) WITH dcounts1
Next
Reply
Map
View

Click here to load this message in the networking platform