Re: MySQL Tools for Visual Studio 1.0.2 GA released!
Posted by: Marcelo Riesco
Date: January 08, 2007 03:40AM

The connector/net does not to work properly:

I have wrote a Stored Procedure wich works perfectl well in MySql:

CREATE PROCEDURE `Sp_InstalacionCol_Sector` () LANGUAGE SQL COMMENT ''
BEGIN
SELECT T1.id_T1, T1.Field,
IF(T1.Field2 = 'MySlq' ,'GoodDataBase' , Null) as Example
FROM Table1 as T1
END

But doesn´t work when I try to use it in visual Basic .net,

oDataAdapter.Fill(oDataset,DatasetName)

This sentence work with most Stored Procedures but doesn´t work with the above Stored Procedure. I think because of the IF function.

I´m working with visual basic .net 2003 and with mysql-connector-net-1.0.4

Thanks

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.