Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Working with Grids and flexible queries
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00415649
Message ID:
00417191
Vues:
26
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform