>>I have a problem that is driving me crazy at the moment. With the following code, I have no errors when I run it in the foxpro environment, but when I compile it and run it from the executable I get to messagebox 1.5, then it gives the error 'File does not exist'. Anybody have any ideas/insights into what could be causing this problem? The code is running from a .prg called by a button on a form.
>>
>>SELECT authffs
>>MESSAGEBOX("starting FFS crosstab 1")
>>SELECT Authffs.saa, Authffs.mo, COUNT(Authffs.compliant);
>> FROM authffs;
>> GROUP BY Authffs.saa, Authffs.mo;
>> ORDER BY Authffs.saa, Authffs.mo;
>> INTO CURSOR SYS(2015)
>>MESSAGEBOX("starting FFS crosstab 1.5")
>>DO (_GENXTAB) WITH 'Query',.t.,.t.,.t.,,,,.t.,1,.t.
>>MESSAGEBOX("starting FFS crosstab 1.6")
>>SELECT query
>>COPY TO ..\data\FFS6motot.dbf
>>MESSAGEBOX("starting FFS crosstab 2")
>
>Is vfpxtab.prg included in your project? BTW, this is included for backward compatibility. You might just want to say DO VFPXTab WITH...

I just tracked down that .prg, added it to my project and changed (_genxtab) to vfpxtab, and it works! Thanks!