Henry,
It can be done with one UPDATE command
UPDATE ClientList ;
SET LastUpdate = CurUpdate, ;
CurUpdate = DATE()
>>Henry,
>>
>>What this code suppouse to acomplish?
>>
>Hi Sergey:
>
>How are you? Basically, each time i run an update, this prg file should update the ClitList.CurUpdate field to the day the update was run. The ClientList.LastUpdate, would be updated to reflect the previous date that was stored in CurUpdate field.
>
--sb--