MySQL Forums
Forum List  »  Stored Procedures

Re: Wrong returnvalue on userdef function
Posted by: Peter Brawley
Date: June 30, 2019 11:24AM

You have a variable named nextnumber which also a column name. Make the names different.

The func needs to cover the possibility that the input param matches no tablename in synewnumber.

BTW Hungarian case helps readability but is not a good idea for MySQL database object identifiers. Best stick to lower case.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

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.