Error with MySqlDataTable and a SELECT with INNER JOIN

Error with MySqlDataTable and a SELECT with INNER JOIN

Postby Massimo » Mon 28 May 2007 15:37

i have this select command:

SELECT comune.*, azienda.* FROM azienda
INNER JOIN comune ON comune.id = azienda.id_comune

in my c# code:

oElenco = new MySqlDataTable(cSelect, VariabiliGlobali.oConn);
oElenco.FetchAll = false;
oElenco.Active = true; --------->

i receive this error:

System.NullReferenceException ........
in CoreLab.Common.DbDataTable.CreateColumns()


The table structure:

CREATE TABLE `comune` (
`id` int(10) NOT NULL auto_increment,
`cap` varchar(5) NOT NULL default '',
`prov` char(2) NOT NULL default '',
`desccomune` varchar(40) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `desccomune` (`desccomune`)
) TYPE=InnoDB;

CREATE TABLE `azienda` (
`id` int(11) NOT NULL auto_increment,
`DescAzienda` varchar(50) NOT NULL default '" "',
`Indirizzo` varchar(50) default '" "',
`Id_Comune` int(11) default '0',
`Telefono` varchar(20) default '" "',
`Fax` varchar(20) default '" "',
`EMail` varchar(100) default '" "',
`Web` varchar(100) default '" "',
`CodiceFiscale` varchar(16) default '" "',
`PartitaIva` varchar(11) default '" "',
PRIMARY KEY (`id`)
) TYPE=InnoDB;


Thanks,
Massimo
Massimo
 
Posts: 13
Joined: Mon 28 May 2007 15:18

Postby Alexey » Tue 29 May 2007 07:34

We are investigating this problem.
You will be notified on results as soon as possible.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Alexey » Fri 01 Jun 2007 14:31

We have fixed this problem.
What version of MySQLDirect .NET do you use?
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Massimo » Mon 04 Jun 2007 09:34

I use MySql Direct.NET version 4.0.9.0 ,MySql Developer Tools version 2.0.19.0 and MySqlDirect.Net Data Provider Mobile 4.0.9.1

There is an other problem with the MySqlConnection (Mobile). If the connection comes interrupted the property State remains Open and not Close. Also after the connection timeout the property State remain always Open. At the time to understand if the connection status i get the result
of Ping() method.

Thanks,
Massimo
Massimo
 
Posts: 13
Joined: Mon 28 May 2007 15:18

Postby Alexey » Mon 04 Jun 2007 11:27

The problem with joined querries is fixed in the latest version of MySQLDirect .NET. Check it out.
As for the State property, this is a designed behaviour. You are right that it is needed to use Ping() method to find out whether connection is still alive.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Massimo » Tue 05 Jun 2007 10:49

Can i have the link page where i can download the update version?

Thanks, Massimo
Massimo
 
Posts: 13
Joined: Mon 28 May 2007 15:18

Postby Alexey » Tue 05 Jun 2007 11:44

If you are registered user, you should download it from the registered users area. The link was provided in the registration letter. Otherwise download it from here.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Massimo » Tue 05 Jun 2007 13:24

How i can register my product licences and subscription basis. I have acquired MySqlDirect.Net2 Mobile and MySqlDirect.Net2 at the April 30, 2007, from www.componentsource.com.

Can i have the link where i can register my product's licences?

Thanks Massimo.
Massimo
 
Posts: 13
Joined: Mon 28 May 2007 15:18

Postby Devart » Wed 06 Jun 2007 11:21

We sent login information to download MySQLDirect .NET Professional and Mobile editions to your email address.

Core Lab Sales
www.crlab.com
Devart
Devart Team
 
Posts: 3007
Joined: Tue 26 Oct 2004 13:51

Postby Massimo » Thu 07 Jun 2007 15:44

Thanks for all.
I have appreciated your engagement, but unfortunately, after the update
at the 4.0.10.0 version i have the same problem with the same error.

This is the image of software version in visual studio

Image

This is the image of correct query with the Developer Tool

Image

This is the image of the error with the MySqlDataTable.active = true

Image




The query is

SELECT azienda.*, comune.*
FROM azienda
INNER JOIN comune ON comune.id = azienda.id_comune

The table structure:

CREATE TABLE `comune` (
`id` int(10) NOT NULL auto_increment,
`cap` varchar(5) NOT NULL default '',
`prov` char(2) NOT NULL default '',
`desccomune` varchar(40) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `desccomune` (`desccomune`)
) TYPE=InnoDB;

CREATE TABLE `azienda` (
`id` int(11) NOT NULL auto_increment,
`DescAzienda` varchar(50) NOT NULL default '" "',
`Indirizzo` varchar(50) default '" "',
`Id_Comune` int(11) default '0',
`Telefono` varchar(20) default '" "',
`Fax` varchar(20) default '" "',
`EMail` varchar(100) default '" "',
`Web` varchar(100) default '" "',
`CodiceFiscale` varchar(16) default '" "',
`PartitaIva` varchar(11) default '" "',
PRIMARY KEY (`id`)
) TYPE=InnoDB;



Thanks Massimo.
Massimo
 
Posts: 13
Joined: Mon 28 May 2007 15:18

Postby Alexey » Mon 11 Jun 2007 07:21

We are investigating this problem.
Look forward to hearing from me soon.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Alexey » Fri 15 Jun 2007 11:22

We have mistakenly fixed this in MySQLDirect .NET 4.10. For now it is fixed in 4.0 as well. Look forward to the new build.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL