Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record pointer...
Message
From
05/06/2001 12:13:36
 
 
To
05/06/2001 12:03:48
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00515179
Message ID:
00515186
Views:
16
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform