>Even if I use GROUP BY 1 for instance instead of the field name? Why do I feel like one of the only people really upset about this. I have a huge application written in fox 7 with errors all over the place now!
>
>Thanks!
>
>John Harms
>HARMS Software Inc.
they brought VFP 8 UP to SQL Server compliance.
lcfiledlist = "CustID, Company, Territory, sum(Invoices.SalesAmount) as Sales "
lcgrouplist = "CustID, Company, Territory"
or
lcgrouplist = "1, 2, 3"
Select (lcfieldlist) from Customers ;
left join Invoices ;
on Customers.CustId = Invoices.CustId ;
group by (lcgroublist)
You now must include all fields in the group by clause. In SQL Server you cannot use the As Named but you will need the exact column description.
This will give you better compliance with other back ends. I see this as a good thing. Lets stop bieing VFP sloppy.
__Stephen