okay, Hugo
That makes a little more sense then Hilmar's statement. I will give it a try.
>Beth,
>
>You can not have any aggregate fields (MAX, SUM, COUNT) without a Group by on all other non aggregate fields. You need to add to your Select a GROUP BY Client_ID clause
>
>>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