Information générale
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement