Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.00 » View Incident Report |
Serious |
Reported By: Heiko Knuettel Reported On: 6/18/2008 For: Version 2.00 Build 1 |
CREATE FUNCTION "strtofloat" (IN "str" VARCHAR(500) COLLATE DEU_CI_AI_KI_WI) RETURNS FLOAT BEGIN declare result float default 0; set result = cast(str as float); return result; EXCEPTION set result = 0; END Workaround: ALTER FUNCTION "StrToFloat" (IN "Str" VARCHAR COLLATE ANSI) RETURNS FLOAT BEGIN DECLARE v FLOAT; DECLARE s VARCHAR; IF Str = '' THEN SET s = ' '; ELSE SET s = Str; END IF; BEGIN SET v = CAST(s AS FLOAT); EXCEPTION SET v = 0; END; RETURN V; END
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |