View Incident Report

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 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

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

More Support Options