Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Update vs REPLACE
Message
 
To
13/12/2000 02:08:00
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00452757
Message ID:
00452848
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform