Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
(SQL) REPLACE seem not right?
Message
De
04/10/2001 10:26:22
 
 
À
04/10/2001 10:18:17
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00564147
Message ID:
00564156
Vues:
20
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform