General information
Category:
Coding, syntax & commands
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only