I've had similar problems with the REPLACE statement. I always select the workarea first.
An alternative is to use the SQL UPDATE command. You do not have to select a workarea with it.
UPDATE auth SET end = DATE(), ;
uplog = ALLTRIM(GETENV("USR")) ;
WHERE auth.organization = org.organization AND ;
(auth.end > DATE() OR EMPTY(auth.end))
>
>REPLACE auth.end WITH DATE(), ;
> auth.uplog WITH ALLTRIM(GETENV("USR")) FOR ;
> auth.organization = org.organization AND ;
> (auth.end > DATE() OR EMPTY(auth.end)) ;
> IN auth
>
>This coding is in while another table is selected (AUTH table is open but not active selected). This coding didn't update anything in the AUTH table? Did I overlooked something? I believe it did worked before (did many tests and appear it did it's code).
>
>Chuck