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