>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

Evan, you use alias name of your cursor, not it's actual DBF name.
Use instead:
DO (_GENXTAB) WITH DBF("dcounts1")


Nick