Reported By: Harry Van Tassell Reported On: 3/22/1999 For: Version 1.13 Build 1
# 384Subtraction 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.
ResolutionFixed Problem on 3/28/1999 in version 1.14 build 1