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

Did this:

SELECT * FROM auth ;
         WHERE auth.organization = org.organization AND ;
         (auth.end > DATE() OR EMPTY(auth.end))

and came up with 8 matching results. Could it be the buffer=5 or ... I mean it worked before and now it doesn't (I know it's one of the Top 20 Programmer's excuses :).

Chuck

>>>

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