Icon View Incident Report

Serious Serious
Reported By: Hedley Muscroft
Reported On: 4/30/2009
For: Version 2.02 Build 11
# 2986 Concatenated CHAR or VARCHAR Columns Can Cause Error When the Length Exceeds 1024 Characters

I've started to run into the following error :-

ElevateDB Error #100 There is an error in the metadata for the column test (The size is above the maximum of 1024)

Sometimes my customers need custom reports with quite a lot of string concatenation. I can understand that a single VARCHAR field must be limited but should a concatenated string have the same limitation?


Comments Comments
ElevateDB now converts any CHAR/VARCHAR expression that exceeds 1024 characters into a CLOB expression instead of issuing an exception, and the same is done for any BYTE/VARBYTE expressions, which are converted to BLOB expressions.


Resolution Resolution
Fixed Problem on 5/1/2009 in version 2.02 build 12


Products Affected Products Affected
ElevateDB 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 LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image