Reported By: Heiko Knuettel Reported On: 6/18/2008 For: Version 2.00 Build 1
# 2666SUBSTR Function Not Handling Non-Constant Parameters for the Second Parameter Properly When executing the following function, I get the error
'' is not a valid integer value
CREATE FUNCTION sflagset(IN str VARCHAR(100), IN fl INTEGER)
RETURNS BOOLEAN
BEGIN
return (substr(str, fl, 1)='J');
END
ResolutionFixed Problem on 6/18/2008 in version 2.00 build 2
Products AffectedElevateDB 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 VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial