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:
00564157
Views:
17
>
 local lcOrganization
 lcOrganization = org.organization && Is it Char or what?
>REPLACE auth.end WITH DATE(), ;
>	auth.uplog WITH ALLTRIM(GETENV("USR")) FOR ;
>	auth.organization = lcOrganization 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

See the change above.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform