DataSet contains more columns. BUG?

DataSet contains more columns. BUG?

Postby trygvelo » Wed 19 Jan 2005 10:59

Hi,

I'm using the latest (2.70) version of the MySQL Direct .NET connector. Discovered something I believe is not correct behaviour today. I have a dataadapter with a select statement like:

SELECT * FROM table

The corresponding datatable in the dataset is however not defined with all the columns that the SQL returns. When I use the dataset designtime it seems to be correct and the columns that are not defined in the dataset is not there, but at runtime those columns have automatically been added to the datatable. Is this correct behaviour?

Regards,
Trygve Lorentzen
trygvelo
 
Posts: 13
Joined: Wed 19 Jan 2005 10:53

Postby Oleg » Wed 19 Jan 2005 16:47

If you want to get not all columns from your table, you must specify these columns in your select SQL.
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56


Return to dotConnect for MySQL