>>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.