Wrong returnvalue on userdef function

[Franz Balleis]

Hi,
I have written several functions that give me different values from another database. All functions except one will return a value. The function shown below only provides OK back.

What am I doing wron



CREATE DEFINER=`mysql`@`%` FUNCTION `getNextSysNumber`( c_number_type varchar(64)) RETURNS int(18)
BEGIN
DECLARE nextnumber INTEGER DEFAULT 0;
SELECT
synewnumber.LastNumber
INTO nextnumber FROM
synewnumber
WHERE
UPPER(TRIM(synewnumber.TableName)) = UPPER(TRIM(c_number_type));
SET nextnumber = nextnumber + 1;
RETURN nextnumber;
END