Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need some arguments
Message
From
21/08/2000 23:25:27
 
 
To
21/08/2000 23:19:20
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00407558
Message ID:
00407606
Views:
25
>Thank you Ed. It’ll help me. And one questions more. If I use commands: LOCATE, UPDATE, REPLACE do fox before copies data to local station. Thank you.

It depends on the scope of the operation and what mechanisms VFP has to attempt to optimize data access. LOCATE, for example, if no mechanism for performing a search is available to optimize access (index tags usable for Rushmore optimization) then the only mechanism available is to examine the table record by record until a record is found that satisfies the FOR expression.

UPDATE/REPLACE are clearly scoped to the FOR; REPLACE by default afects only the current record. If you say REPLACE ALL then it has to manipulate each record.

Read the section on optimizing table access in VFP for documentation.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform