MySQL Forums
Forum List  »  Newbie

Re: Stored Procedure
Posted by: Michael Smith
Date: August 15, 2024 06:32PM

John:

i have run this through MySQL Workbench and the problem seems to be with the line:

@mInvnbr := SELECT Invnbr FROM Invoices02 WHERE Check01 = 1 and EXTRA1 = " ";

The database is connected properly.

I have tied adding brackets, it does not help.

Any thoughts?

Mike

Options: ReplyQuote


Subject
Written By
Posted
August 13, 2024 12:21PM
August 13, 2024 08:04PM
August 14, 2024 12:07AM
August 14, 2024 07:13AM
August 14, 2024 09:44PM
August 15, 2024 07:47AM
August 15, 2024 03:58PM
Re: Stored Procedure
August 15, 2024 06:32PM
August 15, 2024 06:36PM
August 16, 2024 05:25AM
August 15, 2024 05:49PM
August 16, 2024 08:32AM
August 16, 2024 03:41PM
August 16, 2024 09:24PM


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.