FP98: Error Performing Query in HTX File If-Then Conditional

ID: Q194441

The information in this article applies to:

SUMMARY

When you use the Internet Database Connector (IDC) features to query a data source table where the field names begin with a number, you receive the following error message:

Error Performing Query
The template file contains an expression with an unrecognized operator. Valid operators are GT, LT, EQ and CONTAINS.
Field names in the If-Then Conditional section of the HTX file cannot begin with a number.

Rename the field for the results set using the SQL reserved word 'AS'. For example, to use a table field named, "900Line," rename the field as Line900: 

   SELECT 900Line AS Line900 FROM Employees

Additional query words: 98 


Keywords          : fpodbc 
Version           : WINDOWS:
Platform          : WINDOWS 
Issue type        : kbhowto

Last Reviewed: August 2, 1999