Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
(SQL) REPLACE seem not right?
Message
From
04/10/2001 10:26:22
 
 
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:
00564156
Views:
19
I've had similar problems with the REPLACE statement. I always select the workarea first.

An alternative is to use the SQL UPDATE command. You do not have to select a workarea with it.
UPDATE auth SET end = DATE(), ;
	uplog = ALLTRIM(GETENV("USR")) ;
WHERE auth.organization = org.organization AND ;
	(auth.end > DATE() OR EMPTY(auth.end))
>
>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
Thanks,
Dan Jurden
djurden@outlook.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform