Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Update vs REPLACE
Message
De
14/12/2000 15:43:45
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00452757
Message ID:
00453603
Vues:
28
>>REPLACE ;
> field1 WITH "value1", ;
> field2 WITH "value2", ;
> field3 WITH "value3", ...
> IN TableAlias
>
>Al;
>
>Good advice. I would like to suggest two reasons for following your example. First is it is easy to read - with long statements that will make debugging easier. The second reason is the Replace statement is seen and run as one line of code and will thus execute quicker then line by line Replace statements.
>
>Tom

Yes, I'm a big believer in whitespace. Got that from an instructor in an introductory C course about 15 years ago; he actually deducted marks from assignments if there was, in his opinion, insufficient whitespace. Seemed petty and stupid at the time, but looks like genius today...
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform