View Incident Report

Minor

Reported By: Roy Lambert
Reported On: 12/22/2009
For: Version 2.03 Build 6

# 3122 Using the Same Parameter Name with Two Different Column Expressions Can Cause Truncation Errors

I think you have an error in how you handle parameters

exception class : EEDBError
exception message : ElevateDB Error #1011 An error occurred with the value Technical Architect (The value would result in truncation).

with the following SQL query.

SELECT _JobCode FROM JobCodes
WHERE _JobCode = :Value OR _JobDesc = :Value

CREATE TABLE "JobCodes"
(
"_JobCode" VARCHAR(10) COLLATE "ANSI_CI",
"_JobDesc" VARCHAR(35) COLLATE "ANSI_CI",
CONSTRAINT "PK" PRIMARY KEY ("_JobCode")
)

Comments and Workarounds

The workaround is to use a separate parameter name for each column comparison, and then assign them independently.

Resolution

Fixed Problem on 12/23/2009 in version 2.03 build 7

Products Affected

ElevateDB Additional Software and Utilities
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap