Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why CursorFill() is faster than CursorRefresh() in a CA?
Message
From
01/12/2010 03:24:26
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
01/12/2010 03:20:02
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 7
Miscellaneous
Thread ID:
01491162
Message ID:
01491327
Views:
68
>>Why CursorFill() is faster than CursorRefresh() in a CA?
>>Note that both functions returns the same number of records and uses the same SelectCmd...
>
>CursorFill()
>create the CA.Alias dbf
>
>CursorRefresh()
>1. create a temp dbf
>2. copy temp.dbf into the CA.Alias dbf
>
>the step 2. can require enough time,
>and this force the dbf structure to not change

Hi Fabio,

are your shure?

the DBF() is someting like SYS(2015)+'.DBF'
I can see DBF(CA.ALIAS) change with every CursorRefresh.
I run in this indexing a CA / View after Requery / CursorRefresh

Agnes
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform