View Incident Report

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"

Workaround:

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

Comments and Workarounds

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

Resolution

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap