General information
Category:
Coding, syntax & commands
Title:
File not found after cross tab query..
Hi all!
The following command works fine in design mode (Command window), when I compiled the project and create an exe file. When I Click the Command Button (command1) I got an "File not found" error, which refers to "vfpxtab".
Please help me with this problem...
TIA
Mike..
*---
*** COMMAND1.CLICK:***
SELECT S_detail.s_icode, S_detail.doc_num, ;
ALLTRIM(STR(SUM(S_detail.s_qty))+S_detail.s_unit);
FROM ahadata!S_detail WHERE ;
ALLTRIM(salesman)=ALLTRIM(THISFORM.cboSalesman.VALUE);
AND ALLTRIM(prodline)=ALLTRIM(THISFORM.cboProductLine.VALUE);
AND wsdate=CTOD(THISFORM.text2.VALUE) ;
AND SLRDATE=CTOD(THISFORM.txtSLRDATE.VALUE) ;
AND PROMO=0;
GROUP BY S_detail.s_icode, S_detail.doc_num ;
ORDER BY S_detail.s_icode, S_detail.doc_num ;
INTO CURSOR SYS(2015)
DO (_GENXTAB) WITH 'VFPXTAB'
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