MySQL Forums
Forum List  »  MySQL for Visual Studio

Problems creating a query based on existing stored procedure
Posted by: Vadim Rapp
Date: October 01, 2014 08:20AM

I have problems when in Visual Studio I'm trying to create queries to existing stored procedures in MySQL. I create them by adding a dataset to the project, and then adding a query to the dataset, specifying data connection based on mysql connector.

Problem #1: if the stored procedure has parameter, the parameter is not created automatically, and the wizard shows error "parameter 'parm1' not found in the collection.

Problem #2: if the stored procedure has error handler inside, the error kicks in during the design. For example:

CREATE PROCEDURE test(IN parm1 INT)
BEGIN
IF CURDATE() > '2014-1-1'
THEN SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'too late', MYSQL_ERRNO = 1001;
END IF;

END


As soon as in Visual Studio dataset designer I select this stored procedure in the wizard that creates a query, I see the error message, and the parameter is not recognized.

Options: ReplyQuote


Subject
Views
Written By
Posted
Problems creating a query based on existing stored procedure
2135
October 01, 2014 08:20AM


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.