We have a problem when selecting Features from a Feature Class in ArcMAP 10.2 using the Iterate Feature Selection tool in ModelBuilder.
Our dataset has a Attribute Field with two character codes like 'AO', 'IN','BY','TR' and 'IS'. However the tool crashes because the SQL Statment cannot be evaluated. IN, IS and BY are reserved Words in SQL. How can i escape this behaviour?
This is the Error message in the log:
ERROR 999999: Error executing function. An invalid SQL statement was used. An invalid SQL statement was used. [BY] An invalid SQL statement was used. [SELECT * FROM BY] Failed to execute (Feature Class to Feature Class).
And the model is this: