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
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.