Icon View Incident Report

Serious Serious
Reported By: Oliver Bock
Reported On: 8/11/2004
For: Version 4.10 Build 1
# 1808 Using a Plus (+) or Minus (-) Unary Operator In Front of a Currency Column Causes Parses Error

Minus signs in front of MONEY column references do not work. The SQL below yields this error:

DBISAM Engine Error # 11949 SQL parsing error - Expected NULL, SmallInt, Word, Integer, LargeInt, Float, or BCD expression but instead found i in SELECT SQL statement at line 2, column 9

create table "\Memory\t" (i money);
select -i from "\Memory\t"


select -(cast(i AS float)) from "\Memory\t"

Comments Comments and Workarounds
The workaround is to use the CAST() function to cast the value to a Float data type instead.

Resolution Resolution
Fixed Problem on 8/11/2004 in version 4.11 build 1