Icon View Incident Report

Serious Serious
Reported By: Heiko Knuettel
Reported On: 6/18/2008
For: Version 2.00 Build 1
# 2666 SUBSTR 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



Resolution Resolution
Fixed Problem on 6/18/2008 in version 2.00 build 2


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

Image