Devart Forums

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

We are investigating this problem.
You will be notified on results as soon as possible.

We have fixed this problem.
What version of MySQLDirect .NET do you use?

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

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.

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

Thanks, Massimo

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.

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.

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

Core Lab Sales
www.crlab.com

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



This is the image of correct query with the Developer Tool



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






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.

We are investigating this problem.
Look forward to hearing from me soon.

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.