>>>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
>>
>>Try SELECT ... INTO Table dcounts1
>
>What would your crostab line look like. The statement
>
>do(_GENXTAB) with dcounts1 does not work with your suggestion.

I just looked at VFPXTAB.PRG (never used it before) and found that the 1-st parameter is actually output file name, so what happened with both suggestions - you were writing to the source table... :). As I can see you can use no parameter at all, the default output file will be "xtab.dbf"