When executing


CREATE FUNCTION sflagset(IN str VARCHAR(100), IN fl INTEGER)
RETURNS BOOLEAN
BEGIN
  return (substr(str, fl, 1)='J');
END


I get the error


'' is not a valid integer value

EDB 2.00, using EDB Manager

Heiko,

<< I get the error >>

Yep, it's a bug in the handling of the last SUBSTR parameter.  A fix will be
in 2.00 B2.

--
Tim Young
Elevate Software
www.elevatesoft.com