Just a suggestion: did you tried to SET OPTIMIZE OFF before this command running (meant indexes corruption problem or something like that)? Also, are you sure record in "org" selected and contains correct value?

>

>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