What is the max number of items in IN clause? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

What is the max number of items in IN clause?

Message

De

27/04/2010 10:24:12

Naomi Nosonovsky
Wisconsin, États-Unis

À

27/04/2010 10:18:31

Mike Yearwood
Toronto, Ontario, Canada

Information générale

Forum:

Visual FoxPro

Catégorie:

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

Titre:

Re: What is the max number of items in IN clause?

Versions des environnements

Visual FoxPro:

VFP 9 SP2

OS:

Vista

Network:

Windows 2003 Server

Database:

MS SQL Server

Divers

Thread ID:

01462166

Message ID:

01462192

Vues:

59

>>If you add one more, there would be an error.
>
>Use a table then there is virtually no limit.

It was not my question of possible workarounds. I just wanted a confirmation of this particular limit.

If it's not broken, fix it until it is.

My Blog

Click here to load this message in the networking platform