Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid load large cursors fast but small groups very slow
Message
 
À
17/07/1997 16:01:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00040340
Message ID:
00040465
Vues:
35
>> ... WHERE ... AND .T. = .T. ...
>>
>>This force VFP to create a temp table for the cursor and will speed up your grid display.
>
>I use the field AS fieldname which also forces a cursor.
>
>SELECT *,0 AS DUMMY FROM ...
Michel,

That works too.

Except if the result strucutre is critical, then WHERE .T. = .T. doesn't add a field to the result. NOFILTER is the best way in my book (if we are talking VFP 5.0).
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform