Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why CursorFill() is faster than CursorRefresh() in a CA?
Message
From
04/12/2010 03:07:47
 
 
To
03/12/2010 21:17:43
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:
01491725
Views:
57
>Fabio,
>
>"Beserk" in what sense?
>a change in the SELECT ORDER not expected to affect the grid.

>
>That is what I also thought. Any change I make into ANY of the segments in SELECT, ORDER, WHERE will result in my grid going beserk.
>
>A little googling made me find this (which works like a charm):
>
>
>
>* previous to this, create a temp cursor with the same structure as the CA cursors in INIT of form and build up your grid
>
>ThisForm.myGrid.RecordSource = "myTempCursor"
>
>myCursor.CursorFill()
>
>ThisForm.myGrid.RecordSource = "myCursor"
>
>
This is by design.

CursorFill destroy the old Alias.
When the Grid.RecordSource become empty or the dbf is destroyed,
VFP reset the grid structure ( look in Recorsource help )

try this:
ThisForm.myGrid.RecordSource = " "

myCursor.CursorFill()

ThisForm.myGrid.RecordSource = "myCursor"
Previous
Reply
Map
View

Click here to load this message in the networking platform