zzCheckMySqlFunction("""
	CREATE FUNCTION getclnsaldo(_cln integer) 
	RETURNS decimal(15,2)
	COMMENT '1'
	DETERMINISTIC
	BEGIN
	
		declare saldo decimal(15,2) default 0.00;
		
		select 
		(select sum(summa)
		from move0
		where cln=_cln and  _db_cnt in (select cnt from l_abp,spr_abp where l_abp.abp=spr_abp.abp and afield='cln') )
		-
		(select sum(summa)
		from move0
		where cln=_cln and  _cr_cnt in (select cnt from l_abp,spr_abp where l_abp.abp=spr_abp.abp and afield='cln') ) 
		into saldo;

	
		RETURN (saldo);
	END
	""",forceRedefine=1)

if zzIsMySqlFunction("getclnsaldo"):
	zzCursor("select getclnsaldo(43) as saldo").browse()