Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
File not found after cross tab query..
Message
From
26/07/2003 07:45:25
Mike Sontillano
Travellers Life Assurance of the Philipp
Naga, Philippines
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
File not found after cross tab query..
Miscellaneous
Thread ID:
00813735
Message ID:
00813735
Views:
44
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
Map
View

Click here to load this message in the networking platform