There's always grouping involved when you're using aggreagate functions. You can either add
GROUP BY client_id or use variable instaed of a field
SELECT lcclientid , MAX(act_time) ...
>
>I have code in the aftercolchange method to set data up. Now I have a select that use to work, and is now, not working. It is Friday, I know, and I want to go home, so I can not see the problem with this select statement. I do not want to group the results. I am only looking at the first set of data returned.
>
>
> SELECT client_id, MAX(act_time) FROM sup_act ;
> WHERE client_id = lcclientid AND problem_id = lcproblemid ;
> INTO ARRAY latemp
>
>
>I do not see where group by has any thing to do with the statement. Help!
>
>TIA
>Beth
--sb--