ERROR
Note:The following error message occurs even though the WHERE clause, which is very long, appears to be valid.v2006.1:
The ArcWeb Services product line has been retired. ESRI recommends that customers who wish to create Web applications or use services similar to those that were available in ArcWeb Services transition to the capabilities of ArcGIS Server and ArcGIS Online.
The WHERE clause contains too many items. For example the IN statement can only hold 1000 values.
Code:
variable IN ( value1, value2, ... valueN)
Split the IN clause into sets of 1,000-value IN clauses and put them together with the OR command:
Code:
variable IN (value1, value2, ... , value1000) OR variable IN (value1001, value1002, ... , value2000) OR variable IN (value2001, value2002, ... , value2345)
Note:
The ArcWeb Services product line has been retired. ESRI recommends that customers who wish to create Web applications or use services similar to those that were available in ArcWeb Services transition to the capabilities of ArcGIS Server and ArcGIS Online.
Article ID:000007617
Get help from ArcGIS experts
Download the Esri Support App