>

>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