Icon View Incident Report

Serious Serious
Reported By: Suzanne Nuss
Reported On: 12/20/2011
For: Version 2.06 Build 2
# 3526 Remote Queries with Table Correlation Names in SELECT List Cause Error with Sensitive Result Sets

The following query works locally with no issue, but if I run it "remotely" I receive an invalid expression error message:

"ElevateDB Error #700 An error was found in the __Column-1 computed column expression"

Select Client.*,
       Client.LastName + ', ' + Coalesce(Client.FirstName, '') + ' ' +
          Coalesce(Client.MI, '') As FullName
From Client
Order By Client.LastName COLLATE "ANSI_CI" ,
         Client.FirstName COLLATE "ANSI_CI" ,
         Client.MI COLLATE "ANSI_CI"

Resolution Resolution
Fixed Problem on 12/23/2011 in version 2.07 build 1

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