Objects must implement IConvertible

[Gav]

Hi All,

I'm trying to create a table in a sql database.

When I run
ExecuteNonQuery();

I get an error "Objects must implement IConvertible".

I put the same statement in a textbox, after getting the error I copied the
statement into SQL's query analyser and the command works fine.

Anyone know where I might be going wrong?

Thanks
Gav

 

[Vadym Stetsyak]

Hello, Gav!

Can you specify more details about that query, and if it is possible post the code, where you're
building sql query.

--
Regards, Vadym Stetsyak
www: http://vadmyst.blogspot.com

 

[Gav]

I'm sorry it really was a silly mistake of my part I just didn't spot it.

I was creating parameters in the command too early. (there are parameters
for the insert which comes next, and I was setting the parameters before I
called the CREATE TABLE command!! - really must take more care in my coding
before scratching my head)

Thanks anyway
Gav