Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL vfp 8 vs. vfp 6
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00815861
Message ID:
00816013
Views:
19
That's kinda of discouraging(and confusing). I am supposed to think my sql select statements possibly returned incorrect data in vfp7?



>It's documented in VFP8 help under Behavior Changes Since Visual FoxPro 7.0 and INFO: SQL SELECT Behavior Changes in Visual FoxPro 8.0 mskb #813361.
>
>>This statement works in vfp 6 but not vfp 8.
>>Select detail,noun,sum(price),sum(quantity) from s:bsyear03 group by detail;
>>into cursor norton
>>
>>In vfp8 the error message is "SQL:GROUP BY clause is missing or invalid."
>>
>>shall I change my ways?
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform