Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Genxtab
Message
From
16/07/2004 12:07:41
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Genxtab
Miscellaneous
Thread ID:
00925225
Message ID:
00925225
Views:
65
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")
Next
Reply
Map
View

Click here to load this message in the networking platform