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
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges