Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Will this query take long time using SPT?
Message
De
17/11/2000 12:05:17
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Will this query take long time using SPT?
Divers
Thread ID:
00443073
Message ID:
00443073
Vues:
43
Hi All,

Can someone please tell me whether the following query (using SQL pass-through) would take long time if the table grows into millions?

=SQLExec(nMyHandle, "SELECT * FROM mytable WHERE 1=2", "mycursor")

Actually what I want was the exact structure of back-end table and that is why I put a false WHERE clause.

Or is there another way to get the table structure into array or cursor?

Thanks for your time.

Regards
Vijay
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform