>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)