>>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.