Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Probable issues in jumping from VFP6 to VFP9
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01126508
Message ID:
01126528
Views:
31
>It not always will generate an error. Watch for this one: "When using aggregate functions, such as MAX( ), in the SQL SELECT command without a GROUP BY clause, and no matching records are found, Visual FoxPro returns a result set with a single record and _TALLY set to 1. In versions prior to Visual FoxPro 9.0, no records are returned, and _TALLY is set to 0."

Okay, I will keep it in mind, I generally take care not to use a SUM (most used by me) without a group by, but there can be mistakes and maybe it will serve me right to hash the fastest code *g*.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform