Reported By: Michael Thompson Reported On: 4/8/2007 For: Version 1.02 Build 1
# 2302SUBSTRING 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 and WorkaroundsThis issue did not occur with sensitive (live) result sets, only insensitive (static) result sets. The workaround was to use a sensitive result set instead.
ResolutionFixed Problem on 4/16/2007 in version 1.03 build 1
Products AffectedElevateDB 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