Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SELECT STATEMENT produces different results in VFP 8 and VFP 9
To all, Thanks for your answers. We have decided that we are going to set ANSI on to make sure the behavior of the queries is the same in 8 and 9. I have tried this and it works. I was looking for a way to have to change the least amount of programs as we migrate to 9. Believe it or...- paparupps
- Post #7
- Forum: Microsoft: FoxPro
-
SELECT STATEMENT produces different results in VFP 8 and VFP 9
Thanks, but that doesn't alleviate the problem. I was sure the issues was with EXACT or ANSI until I verified that the settings were the same.- paparupps
- Post #3
- Forum: Microsoft: FoxPro
-
SELECT STATEMENT produces different results in VFP 8 and VFP 9
I am having a problem where a query produces different results based on whether it's run in VFP 8 or VFP 9. Here is the query : SELECT DISTINCT gage.gageno, gage.loc, gage.lastused, gage.duedate, gage.outofserv, gage.gagedesc, gage.customer, gagepart.partno FROM gage LEFT JOIN gagepart ON...- paparupps
- Thread
- Replies: 15
- Forum: Microsoft: FoxPro
