2 replies to this topic

[Lop]

I'm using this code

 System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(sql, odbc);


                //Run the command

                System.Data.Odbc.OdbcDataReader reader2 = cmd.ExecuteReader();


                // See if the row already exists

                if (reader2.HasRows == false)

but HasRows always returns false. Is this a bug or am I doing something wrong?

[Lop]

Problem solved. I had a error in my SQL statement which made HasRows always false.

[Ronin]

haha, that is funny. I do this kind of thing all the time.