English

Problem: Invalid Syntax error occurs when attempting to process query

Description

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.

Cause

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'.