Hi!

I'm just trying to execute a simple INSERT statement:

           using (Elevate.ElevateDB.Data.EDBCommand cmd = new Elevate.ElevateDB.Data.EDBCommand("", Conn))
           {
               Conn.ChangeDatabase("MyDatabase");
               cmd.ParamCheck = true;
               cmd.CommandText = "INSERT INTO Doc(DocName, Extension) VALUES(:DocName, :Extension)";

               cmd.Parameters["DocName"].Value = "blah";
               cmd.Parameters["Extension"].Value = "bluh";
               
               cmd.ExecuteNonQuery();
           }

I'm getting a EDBException (inner ex. is a NullReferenceException).
Stack trace:

  bei Elevate.ElevateDB.Data.EDBCommand.Execute()
  bei Elevate.ElevateDB.Data.EDBCommand.ExecuteNonQuery()
  bei ElevateDB.Form1.DocTestBtn_Click(Object sender, EventArgs e) in...

Do i have to set DbType or Size to the automatically created EDBParameter objects?

Regards an thanks,
Jan

Hi Jan,

I believe that the ODBCConnection has to be Open() before you can use the ChangeDatabase() function.

Chris Holland
[Team Elevate]

----------------------------------------------------------------------

Jan wrote:

Hi!

I'm just trying to execute a simple INSERT statement:

           using (Elevate.ElevateDB.Data.EDBCommand cmd = new Elevate.ElevateDB.Data.EDBCommand("", Conn))
           {
               Conn.ChangeDatabase("MyDatabase");
               cmd.ParamCheck = true;
               cmd.CommandText = "INSERT INTO Doc(DocName, Extension) VALUES(:DocName, :Extension)";

               cmd.Parameters["DocName"].Value = "blah";
               cmd.Parameters["Extension"].Value = "bluh";
               
               cmd.ExecuteNonQuery();
           }

I'm getting a EDBException (inner ex. is a NullReferenceException).
Stack trace:

  bei Elevate.ElevateDB.Data.EDBCommand.Execute()
  bei Elevate.ElevateDB.Data.EDBCommand.ExecuteNonQuery()
  bei ElevateDB.Form1.DocTestBtn_Click(Object sender, EventArgs e) in...

Do i have to set DbType or Size to the automatically created EDBParameter objects?

Regards an thanks,
Jan

Hi Chris!

> I believe that the ODBCConnection has to be Open()
> before you can use the ChangeDatabase() function.

The connection (ADO.NET) is open an i can execute SELECT statements.
Apart from that the driver should not throw a NullReferenceException if the connecion is closed.

Regards,
Jan

Hi!

I have just realized, that the INSERT statement was executed. A new row was inserted properly into the table.
So the exception is thrown after the execution...

Regards,
Jan

Jan,

<< I'm getting a EDBException (inner ex. is a NullReferenceException). >>

This was fixed in 2.05 B8:

http://www.elevatesoft.com/incident?action=viewrep&category=edb&release=2.05&incident=3455

--
Tim Young
Elevate Software
www.elevatesoft.com