Icon View Incident Report

Serious Serious
Reported By: Lawrence Lustig
Reported On: 2/3/1999
For: Version 1.09 Build 1
# 276 Concatenation of String Fields in SQL Expression Engine Not Working Properly

An apparent problem. The following select runs ok, and produces data like LawrenceLustig:

SELECT (FirstName+LastName) AS Claimant FROM people

The following select, however, returns NULL or empty columns:

SELECT (FirstName+' '+LastName) AS Claimant FROM people.

Comments Comments
Problem was in the expression evaluation engine.

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