>>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
Nice to have you back, Ed. Wellcome!
If it's not broken, fix it until it is.
My Blog