Are you sure the WHERE clause is actually matching any records? Try a SELECT using the same where clause to see if any records are selected.

>>

>>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

>
>I am still not able to get this working??? All the tables are opened SHARED and I could understand the REPLACE may not work (even if it did worked before in SHARED), but the UPDATE does not work? I am using buffer=5 (with =TableUpdate(.T.) later on the same code page). I read the Language Referances carefully.
>
>I haven't even thought about what will happen if the user is updating a record (like RLOCK, but not using that command) and then issue this UPDATE. But, first thing first, I need to see what is wrong or why it's not working... I like to stay with UPDATE-SQL.
>
>Again, I did other advices too and still not helping.
>
>Chuck