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