Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Question about REPLACE command
Message
From
09/04/2002 14:21:11
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00642783
Message ID:
00642810
Views:
8
The second way is faster because VFP replaces all the fields at one time rather than individual fields.

>Hi everybody,
>
>When adding or modifying a row in a table, we do the following :
>
>RLOCK()
>REPLACE FIELD1 WITH VALUE1
>REPLACE FIELD2 WITH VALUE2
>REPLACE FIELD3 WITH VALUE3
>...
>UNLOCK
>
>Would it be better (and why would it be) to do :
>
>REPLACE FIELD1 WITH VALUE, FIELD2 WITH VALUE2, FIELD3 WITH VALUE3, ...
>
>
>Thanks in advance...
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform