>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
Probably, 'auth' is not a current work area (unless you do not have temp relationships between the tables). You may use cleaner code:
nOrganization=org.organization
REPLACE auth.end WITH DATE() FOR ;
auth.organization = nOrganization AND ;
(auth.end > DATE() OR EMPTY(auth.end)) in auth
Edward Pikman
Independent Consultant