I don't think that buffering should have anything to do with it. However, you might try it without buffering. Other than that, I don't have any other suggestions at this time.

>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