Any limit for Select-SQL's IN when using a list? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Any limit for Select-SQL's IN when using a list?

Message

De

03/10/2003 14:06:37

Frederico Tomazetti
Brésil

À

03/10/2003 14:03:39

Jim Nelson
Toronto, Ontario, Canada

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: Any limit for Select-SQL's IN when using a list?

Divers

Thread ID:

00834930

Message ID:

00834931

Vues:

25

I have using it with a lot of items (also returning from a sub-select) and I never has any problem.

>I know that the VFP function INLIST() has a limitation of 24 items in its list.
>
>Does the SQL-Select IN (I1, I2, I3...) have any limit other than VFP's overall line length limit?
>
>Thanks

Click here to load this message in the networking platform