Icon View Incident Report

Serious Serious
Reported By: Elevate Software
Reported On: 11/12/2002
For: Version 3.19 Build 1
# 1262 Adding Two Quoted Fields Together in an SQL Expression Results in a Type Mismatch Error

Performing an arithmetical operation on two quoted identifiers in an SQL statement fails:

SELECT "Order Price"   "Tax Amount" AS TOTAL FROM TABLE

Comments Comments and Workarounds
Using square brackets instead of quotes resolves the problem. The problem cannot be solved without making it impossible to add a quoted constant that contains the name of the field to a quoted field name. The use of brackets gets around this.

Resolution Resolution
Cannot Fix Problem