Hi!
Add at the end of the command ' IN auth'
If the current alias is org, recod will move there. Replace uses the current alias as a main recordset, if 'IN' is not specified. If eof() in current alias, for example, it will not replace a field in another alias despite you specified it and despite the target alias is not eof().
HTH.
>First, I have the ORG table selected and then do the following:
>
>REPLACE auth.end WITH DATE() FOR ;
> auth.organization = org.organization AND ;
> (auth.end > DATE() OR EMPTY(auth.end))
>
>and it moves the record pointer of the ORG table. Why?
>
>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.