Reported By: Fernando Dias Reported On: 9/20/2008 For: Version 2.01 Build 5
# 2802Using Computed Expressions in Derived Tables Results in Conversion Error The following statement raises an exception:
ElevateDB Error #1011 An error occurred with the value 1 (A conversion error occurred)
SELECT x1 FROM
(
SELECT CAST(TRIM(BOTH ' ' FROM t1) AS INTEGER) AS x1 FROM Tbl1
)
AS Tbl2
ResolutionFixed Problem on 9/21/2008 in version 2.02 build 1
Products AffectedElevateDB Additional Software and Utilities ElevateDB DAC Client-Server ElevateDB DAC Client-Server with Source ElevateDB DAC Standard ElevateDB DAC Standard with Source ElevateDB DAC Trial ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial