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
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