>>
>>select * from myCurs1 c1 ;
>> where end_time = ;
>> (select max(end_time) from myCurs1 c2 where c1.room == c2.room)
>>
>
>Cetin,
>
>Are you sure that the above could be applied to VFP 8? I am getting syntax error on the SQL Select so I thought maybe the code above is only applicaple to VFP 9.
>
>UPDATE: My mistake. Sorry.
FYI Above code is fox2x and up compatible.
Cetin