Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't figure out Error
Message
From
04/02/1999 23:15:24
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00184055
Message ID:
00184195
Views:
20
>
REPLACE field WITH value ALL
>(same as:
>SCAN
>  REPLACE field WITH value
>ENDSCAN)
>or:
>
REPLACE field WITH value FOR condition

>(same as:

>SCAN FOR condition
>  REPLACE field WITH value
>ENDSCAN
These are the same in function, Rich, but not implementation. Using a FOR clause is fine if you are confident that no other users will be adding records to the table duringthe execution of your command. But since REPLACE and DELETE, when used with the FOR clause lock the table header, other users will be prevented from adding records to the table during the execution of the command. So, sometimes, even though it mightn't be as fast, a SCAN loop is desirable.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform