Problem with NULL values

[Jonas Hansson]

Hi,
I have a problem regarding NULL values in a database when I retrieve the
data with the MySqlDataAdapter fill a DataSet with the returned value.
Whenever the SQL statement returns data that has a column of which the
first row has the value NULL, that whole column will be NULL for all
retrieved rows. Do I have to set a specific value in the
DataSet/MySqlDataAdapter for it to work as expected or is it a bug or is
it somehow supposed to work this way?

--
Jonas

[Patrik Löwendahl [C# MVP]]

This sounds like something out of the ordinary, I've never experienced
anything similar.

The data table isolates all rows from each other and should not "remeber"
column data from previous rows.

Either this is a bug in the MySqlDataAdapter or your query is somewhat
strange.

--
Patrik Löwendahl [C# MVP]
www.cshrp.net - "Elegant code by witty programmers"

"Jonas Hansson" <fa**@bogus.com> wrote in message
news:opsfmoojnqs7evie@randag...

Hi,
I have a problem regarding NULL values in a database when I retrieve the
data with the MySqlDataAdapter fill a DataSet with the returned value.
Whenever the SQL statement returns data that has a column of which the
first row has the value NULL, that whole column will be NULL for all
retrieved rows. Do I have to set a specific value in the
DataSet/MySqlDataAdapter for it to work as expected or is it a bug or is
it somehow supposed to work this way?

--
Jonas

[Jonas Hansson]

On Sun, 10 Oct 2004 13:30:21 +0200, Patrik Löwendahl [C# MVP]
<pa**************@csharpsweden.com> wrote:

This sounds like something out of the ordinary, I've never experienced
anything similar.

The data table isolates all rows from each other and should not "remeber"
column data from previous rows.

Either this is a bug in the MySqlDataAdapter or your query is somewhat
strange.

I guess it's a bug in the MySqlDataAdapter then :/, because if I
copy/paste my SQL statement(s) directly into my db-client then it returns
all the values as I expect them.

--
Jonas
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/