Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grids & CursorAdapter CursorFill()
Message
From
08/01/2011 05:31:59
 
 
To
07/01/2011 22:44:56
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MySQL
Application:
Desktop
Miscellaneous
Thread ID:
01494587
Message ID:
01495223
Views:
87
>Tore,
>
>Have you tried with a dummy cursor as an intermediate stage? Since VFP usualy will be smart enough to use the same cursor again, the delay may be zero. Something like
>
>
>myCA.CursorFill()
>select * from (myCA.Alias) into cursor curdummy
>SELECT Tempcursor    && where Tempcursor is the 'permanent' RecordSource of myGrid
>ZAP
>APPEND FROM DBF(curdummy)
>myGrid.Refresh()
>myGrid.SetFocus()

>
>I will try this out. Forgive my ignorance though, but what is the wisdom or logic behind having to do an intermediate cursor?
>
>Dennis

The "safe select" solution works in all scenarios I have encountered, but clearly not in yours. The only difference is that in your case you use a CA. The intermediate cursor will "build a bridge" between the proven safe solution and the CA. I will surprised if this solution does not work.

NB! It may be necessary to add READWRITE to make sure that you create a brand new intermediate cursor, but I guess not.
Previous
Reply
Map
View

Click here to load this message in the networking platform