Hi Zsolt,
The problem probably has something to do with an exception that is
not handled.
Try using a cursor (for example):
BEGIN
DECLARE done INT DEFAULT 0;
declare Akt_keszlet float(5,2) ;
DECLARE cur CURSOR FOR SELECT IFNULL(
(Select tr_aktualis_keszlet
From `termek_raktarhely`
Where tr_termek_azon=termek_azon
and tr_raktarhely_azon=raktar_azon), 0);
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
OPEN cur;
Akt_keszlet = 0;
REPEAT
FETCH cur INTO Akt_keszlet;
UNTIL done
END REPEAT;
CLOSE cur;
Return Akt_keszlet ;
END
- Paul
On May 8, 2007, at 2:03 PM, Zsolt Csillag wrote:
Hello,
I have the following function in Mysql:
CREATE FUNCTION `GetTermekAktualisKeszlet`(termek_azon INTEGER(11),
raktar_azon INTEGER(11), hosszban_tarolt_termek CHAR)
RETURNS float(5,2)
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ''
Begin
Declare Akt_keszlet float(5,2) ;
SELECT IFNULL(
(Select tr_aktualis_keszlet
From `termek_raktarhely`
Where tr_termek_azon=termek_azon
and tr_raktarhely_azon=raktar_azon)
,0) into Akt_keszlet;
If Akt_keszlet Is Null THEN
set Akt_keszlet = 0;
END If;
Return Akt_keszlet ;
End;
The function above returns either 0 or a value on every MySql
database,
including mine.
However at a new customer this returns NOTHING. (not even NULL).
How can I correct this problem?
Even if I put the line set Akt_keszlet =5 before Return doesn't
help getting
a number (in this case returns with nothing, too).
Thank you very much for your help.
--
Zsolt Csillag
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
