Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Any limit for Select-SQL's IN when using a list?
Message
 
À
04/10/2003 06:16:32
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00834930
Message ID:
00835227
Vues:
22
>AFAIK IN (...) has 24 limit (1 less than 25 inlist limit).
>Even if it did pass the limit it'd be prone to hit command line length limit.
>Whenever I need such a thing I create a cursor to hold inlist items and use
>that cursor for IN part.

That isn't always possible, Cetin -- a GIS program trying to get Fox data on more than 24 locations doesn't have that option, for example.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform