Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
(SQL) REPLACE seem not right?
Message
 
 
To
04/10/2001 10:18:17
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00564147
Message ID:
00564226
Views:
12
>
>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

Maybe org table is at EOF?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform