Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Problem only in EXE
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL Problem only in EXE
Miscellaneous
Thread ID:
00530538
Message ID:
00530538
Views:
60
I have a problem. This query:

SELECT r.*,r.cntrycode AS iso_country_symbol,c.DESCRIPTION ;
FROM results r LEFT OUTER JOIN c_corpact c ;
ON r.sedol = c.sedol and r.todate = DTOS(c.event_date) ;
WHERE ABS(r.index_bip_effect) >= THISFORM.txtBipFilter.VALUE ;
INTO CURSOR results

returns different results when run in the VFP environment than when it runs in an exe. In VFP, the "c.Description" field is populated, like it should be. When it's compiled into an exe, it doesn't get filled in (unless I run the exe in VFP). Is there something I'm missing here? I'm very lost.
Next
Reply
Map
View

Click here to load this message in the networking platform