Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Form does not release
Message
 
 
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Miscellaneous
Thread ID:
00740845
Message ID:
00743036
Views:
27
Ernest,

If you use a view you can avoid reconstructing the grid.

You can also play the trick of setting grid.RecordSource = "", re-select, restore grid.RecordSource. But I prefer to use a view instead, I think it's cleaner.

>David this worked out perfectly. Not only the form releases instantly but populating the 16000 records was reduced as well from about 20 to 1 second. The only down side was having to rebuild the grid after each query (well worth the extra coding). Thanks again.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform