>>>Hi All,
>>>
>>>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
>>
>>Because of the max(), all records are implicitly grouped into a single record.
>>
>>Perhaps you mean:
>>
>>... group by client_id - to get the max for every client.
>
>I want the max time for the client and problem id that match the criteria in the where statement.

In that case you don't strictly need to include field client_id, since you already have it in a variable. It is this field which causes the GROUP BY invalid message.