>>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")

Are you sure this is right? I am still having problems. Wouldn't one use alias("dcounts1") ?