Icon View Incident Report

Serious Serious
Reported By: Harry Van Tassell
Reported On: 3/22/1999
For: Version 1.13 Build 1
# 384 Subtraction Operator Not Being Handled Properly in SQL Statements

The SELECT statement SUM(i2.qty * p.listprice * (1-i2.Discount/100)) works OK but if you eliminate the space after the 1 in (1-i2... one gets an invalid number type error. I assume this is a parsing problem.


Resolution Resolution
Fixed Problem on 3/28/1999 in version 1.14 build 1
Image