Icon View Incident Report

Serious Serious
Reported By: Rolf Frei
Reported On: 12/5/2003
For: Version 3.27 Build 1
# 1718 Using NULL String Constant Expressions in SQL SELECT Columns Causes Invalid Field Definition Error

Empty strings cause an "Invalid field definition" error when used in SQL.

SELECT PartNo, '', '', Description + AdditionalDesc1 + 
AdditionalDesc2, Price1 FROM Parts

Comments Comments and Workarounds
This will also be fixed in the upcoming 3.28 release for 3.x. Empty strings now default to VARCHAR(<Max Field Size>).

Resolution Resolution
Fixed Problem on 2/10/2004 in version 3.28 build 1