Subject Re: Stored Proc
Author skotaylor
--- In firebird-support@yahoogroups.com, Milan Babuskov <albis@e...>
wrote:
> skotaylor wrote:
> > but when I run the SP via "SELECT * FROM drv_hours(:DrvID)" it returns
> > null for all three values.


> Try to put:
> CYCLE14 = 0;
> CYCLE8 = 0;
> CYCLE7 = 0;
>
> before the loop. I guess that values are initializet to null, so when
> you add any number to null, you get null.
>
> HTH

That helps a lot, fixed it even. Must be brain damage, I knew it was
obvious just didn't see it. ;)

Cheers.

Skot.