Reported By: Elevate Software Reported On: 11/12/2002 For: Version 3.19 Build 1
# 1262Adding 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 and WorkaroundsUsing 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.