MySQL Forums
Forum List  »  Newbie

Posted by: Barry Galbraith
Date: March 19, 2023 12:56AM

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,

Options: ReplyQuote

Written By
March 15, 2023 03:31PM
March 19, 2023 12:56AM
March 22, 2023 01:34PM
March 22, 2023 05:02PM
March 22, 2023 07:21PM
March 23, 2023 01:54AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.