Problem: Invalid Syntax error occurs when attempting to process query
An Invalid SQL Syntax Error occurs after clicking 'Finish' to process an SQL Query while changing the shapes or attributes of a database theme.
This error occurs when using Arcview GIS 3.3 with Database Access 2.1c, 2.1d, 2.1e, 2.1f and Informix DBMS.
This is a known problem with Informix DBMS.
Solution or Workaround
The user must move the cursor off the operators '(and)' or '(<)' in the sql query statement before continuing to process his SQL query with 'Finish'.
Last Published: 5/5/2016
Article ID: 000005291