Re: IF ELSE

[Barry Galbraith]

You pass in a parameter named NINVS.
Then then gine table Invoices01 an alias of NINVS, so NINVS goes from being an
int passed in to an alias for a table !?
If you don't want to overwrite your parameter, then use a different name. I like to name my paramters p_para_name.

Then you compare NINVS (which is a table) to 0 !?!?

I suspect confusion reigns supreme.
If you want to compare the count(ITEM) value to 0 then will need to select it into a variable, and compare that to 0.

Good luck,
Barry.