General information
Title:
Crosstab giving errors
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only