General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Trey,
Working just fine in VFP7. Adding any of the aggregates gives me "Cannot GROUP by aggregate field." Adding the payroll logical was my first guess - no dice. Same error. Guess here that the IIF() constitutes an aggregrate field?
>>CLeaning up DBC prior to moving an app into VFP8, and the following view is giving me grief as far as the grouping. Can someone let me know what the problem is?
>
>Is it giving problems in VFP8 or before the move?
>
>if after, it needs the payroll column in the group by [all non-aggregate columns in select are now required in the group by]
>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only