Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Cursor mysteries
Message
From
30/09/2015 20:44:13
 
 
To
30/09/2015 19:45:41
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01625276
Message ID:
01625280
Views:
50
>
>Seems like the alias is not open when the grid instantiates. Or it was recreated after the grid already caught it, i.e. closed then re-created. You may use the so-called 'soft select' technique, to have the cursor created in code, then zapped and filled from the query's cursor whenever necessary. That way the grid's cursor is not closed and re-created and the grid doesn't rebuild.

Good ideas.
Thanks, Dragan
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Previous
Reply
Map
View

Click here to load this message in the networking platform