Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Working with Grids and flexible queries
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00415649
Message ID:
00417191
Views:
27
Bill,

>If your grid uses RecordSourceType 1 (Alias) and this Alias is a Cursor created with an SQL Query, you MAY need to do as I suggested. i.e.

>grid.RecordSource = ""
>SELECT cols FROM table WHERE somecondition INTO CURSOR somecursor NOFILTER
>grid.RecordSource = "somecursor"

I'm doing this, but on the grid.RecordSource = "somecursor", the system sits and spins for about 15 minutes. The cursor starts with about 100,000 records and goes down to 2. I've verified that it is this line that is causing the delay. I'm going to review views to see if that is an option. If you have any further ideas on what I'm doing wrong, I'd appreciate the advice.

Thanks,

Rod
Rod Lewis
Previous
Reply
Map
View

Click here to load this message in the networking platform