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?
>>
>
>Hmm, iif()s group by just fine as far as i can tell.
>SWAG: You sure you got the column number right in the group by? [he says from too much experience...]
LOL! Me too :-) I have tried them by number(position), field names, the AS names. I'm at a loss. I'm about to toss it and start over. It's going to be a long weekend... Thanks, Trey.
Previous
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