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:50:23
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
01/12/2010 03:47:17
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:
01491333
Views:
51
>>>>>>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
>>>
>>>try to attach the CA.alias to a Grid.
>>
>>Done
>>DBF() changes with every cursorrefresh Simple to see on Statusbar
>>
>dbf here does not change.
>
>>No idea why the grid should make a difference
>
>Grid do not like if recordsource file handle change

I have no idea what you are refreing too.
I use a CA bound to a grid with Cursorrefresh since the time the CA was introduced. I have replaced the views (formerly used) with CA and have no problems with grids at all.
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