Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Update vs REPLACE
Message
From
14/12/2000 15:43:45
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00452757
Message ID:
00453603
Views:
27
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform