ExecuteNonQuery Create Table error

[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

 

[Guest]

Hi,

I think Iconvertible is a Interface. You have to use a datatype, which
implemtents Iconvertible. There is a list in the SDK, where the datatypes
are described. Using one of them should solve your problem.

Mfg Bruce

_____

(e-mail address removed)

 

[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.

Thanks anyway
Gav