Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any limit for Select-SQL's IN when using a list?
Message
From
03/10/2003 14:09:45
Aleksey Tsingauz
Microsoft
Seattle, Washington, United States
 
 
To
03/10/2003 14:03:39
Jim Nelson
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Any limit for Select-SQL's IN when using a list?
Miscellaneous
Thread ID:
00834930
Message ID:
00834935
Views:
22
>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

Yes, SQL-Select IN (I1, I2, I3...) has the same limit.

Thanks,
Aleksey.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform