Icon View Incident Report

Serious Serious
Reported By: Michael Thompson
Reported On: 4/8/2007
For: Version 1.02 Build 1
# 2302 SUBSTRING Function Not Working Properly with Insensitive Result Sets

The code below produces wrong view on the Patients field it appears the Length function is not working....

Select SubString(Subject From 4 For Length(Subject)-7) AS Patients, 
Notes from WaitList



Comments Comments and Workarounds
This issue did not occur with sensitive (live) result sets, only insensitive (static) result sets. The workaround was to use a sensitive result set instead.


Resolution Resolution
Fixed Problem on 4/16/2007 in version 1.03 build 1


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

Image