Re: Function returns with NOTHING in a particular database

2007-05-08 Thread Zsolt Csillag
Hello Paul, Thank you for the fast answer. I tried your method, but the result is the same. What is very interesting, the same sql with just the same parameters works perfectly OUTSIDE of the function (I mean in an Sql window). So the same code works in sql window but not in the function. Anoth

Re: Function returns with NOTHING in a particular database

2007-05-08 Thread Paul McCullagh
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_raktarhel