Icon View Incident Report

Serious Serious
Reported By: Lawrence Lustig
Reported On: 2/3/1999
For: Version 1.09 Build 1
# 277 Total Size Not Being Correctly Calculated for Concatenated String Fields in SQL Columns List

It appears that if you use SELECT and select a text expression (say two columns concatenated) to produce a computed value, and you have established a persistent field object, then the Size property of the field object must exactly match the sum of the length of the fields in the expression. If not, you get an error and the query can't execute.

This causes problems in cases where you want to conctenate some litersl text into the expression, or where you may want to repeat the query with a different actual expression. It would be better if the results of the expression were simply put into the field regardless of whether the lengths matched or not--if the field object size were too small, of course the text wouldc be truncated.

Comments Comments
The expression engine was not handling concatenation of string fields properly when calculating the resultant length. For example, using Company+' '+Company where Company is 30 characters in length would result in a length of 62, when the length should have been 61.

Resolution Resolution
Fixed Problem on 2/3/1999 in version 1.10 build 1