Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Maximum JOINs??
Message
De
04/09/1998 09:59:09
 
 
À
04/09/1998 09:50:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Divers
Thread ID:
00133257
Message ID:
00133262
Vues:
14
>Hi,
>
>I am trying to use several JOINs in a SELECT-SQL, but if I specify more than 9 joins, then VFP gives an error while executing the query. The error (#1805) is as follows:
>
>SQL:Too many subqueries.
>
>And to top that, I am not using any subqueries at all.
>
>Any idea?
>
>TIA,
>Hardik

You can always split you big SELECT to chain of smaller ones, and it will work faster. Start the chain with SELECT which will return smaller recordset.
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform