VS2005 Crashed when addin a SP to a DataTable

poirazis · Post by **poirazis** » Thu 03 Aug 2006 10:07

I am running VS2005 and MySQLDirect.Net 3.50.11. When I try to add an new query to a TableAdapter of type Stored procedure, I get the popup to select the stored procedure, and as soon I select the SP i want, poof, the IDE crahses and closes , no error message. The SP is tested from withn the DP Explorer and works like a charm. Am I missing something here ?

Regards
Michael Poirazi

Alexey · Post by **Alexey** » Thu 03 Aug 2006 10:19

We cannot reproduce such strange behaviour.
What is the full version of Visual Studio you use? Professional or Standard?
Specify your hardware architecture: x32 or x64?
What version of MySQLDirect .NET do you use (Std, Pro)?
Do you write class library (dll), executable application (exe), web project,
web project with dynamically compiled sources?

poirazis · Post by **poirazis** » Thu 03 Aug 2006 10:27

I am running VS Pro
MySQL Direct.net Pro
Centrino Duo x32
XP PRo 32
Web Project, Dynamically compiled sources.

poirazis · Post by **poirazis** » Thu 03 Aug 2006 10:31

Another point. The SP doesnot return a RECORDSET, only a value in an OUT paramerer

Alexey · Post by **Alexey** » Thu 03 Aug 2006 10:42

Could you send your stored procedure?

poirazis · Post by **poirazis** » Thu 03 Aug 2006 11:47

PROCEDURE sp_UniqueUsername`(IN _Username VARCHAR(50), OUT UsernameUnique BOOL)
BEGIN
DECLARE _ID Int DEFAULT 0;
SET UsernameUnique = FALSE;

SELECT id INTO _ID from users where Username = _Username;
IF (SELECT _ID = 0) THEN
SET UsernameUnique = TRUE;
END IF;

END

Alexey · Post by **Alexey** » Thu 03 Aug 2006 13:27

I could reproduce popup window vanishing. The IDE itself doesn't crashes.
Now we are investigating this problem. You will be notified on results as soon as possible.

Serious · Post by **Serious** » Fri 04 Aug 2006 16:12

We have fixed this problem for the MySQLDirect .NET.

Look forward for the next build.

poirazis · Post by **poirazis** » Sat 05 Aug 2006 09:36

When will the next build be available ?

Serious · Post by **Serious** » Mon 07 Aug 2006 06:29

New build will be released in a few days.

poirazis · Post by **poirazis** » Tue 15 Aug 2006 15:33

Can we have a more specific estimation when the next build will be available ?

Alexey · Post by **Alexey** » Wed 16 Aug 2006 10:13

We are going to make a new build today.

poirazis · Post by **poirazis** » Thu 17 Aug 2006 12:19

Have you made the build ? Where can I get it from ?

Alexey · Post by **Alexey** » Fri 18 Aug 2006 07:47

Yes, we've built it. Now it is being tested.
Thanks for your patience.

Alexey · Post by **Alexey** » Mon 21 Aug 2006 15:00

New build of MySQLDirect .NET version 3.50.12 is available for download now.