>I get most of the views that use tables in the database to be created as remote views. I get the error 8120. Column 'invdetail.product' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. I get the same error on a couple of my views. I don't know understand why I get it. Do you know a little bit about this error?
Hy Tyler,
The select
SELECT filed1, field2, COUNT(*) ;
FROM mytable ;
GROUP BY field1
is valid in VFP but generates above mentioned error in Sql Server. Only fields specified in GROUP BY clause or aggregate functions are allowd in SQL Server. The following select is valid for SQL Server.
SELECT filed1, field2, COUNT(*) ;
FROM mytable ;
GROUP BY field1, field2
--sb--