Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any limit for Select-SQL's IN when using a list?
Message
 
To
04/10/2003 06:16:32
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00834930
Message ID:
00835227
Views:
21
>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?
Previous
Reply
Map
View

Click here to load this message in the networking platform