Icon View Incident Report

Serious Serious
Reported By: Michael Eubanks
Reported On: 3/27/2002
For: Version 3.08 Build 1
# 1080 Using Field Names with Spaces in Them Inside of SQL Expressions Causes Type Mismatch Error

I am using Delphi 6 and DBISAM C/S version 3.08 How to duplicate using DBSys:

1. Create a table with 2 fields of type BCD size 2

2. Enter data for the new table using DBSys and enter the following:

Value 1 Value 2
12.50 12.60
10.80 13.00
45.23 46.23

3. Execute the following SQL: select sum("Value 1" - "Value 2") from new

You will receive the following error:

DBISAM Engine Error #11949 SQL Error - Type mismatch between column 'Value
1' and constant 'Value 2' in source columns

Note you can make this work by type casting value 1 and value 2 as a float.

Comments Comments and Workarounds
Problem was with the expression engine thinking the second field was a constant value when it shouldn't. The workaround is as indicated by the reporter.

Resolution Resolution
Fixed Problem on 3/29/2002 in version 3.09 build 1