using sql with delphi6 - evariant error

[yomyom]

hello all,
How do I overcome this error?
I'm using sql tables vwith this definition:
create table.....
name varchar (20),
number int constraint pknumber primary key ....
.....
however, when I try to run delphi using ado connection to the sql table i get this error at startup:
exceptionclass evarianterror with message "invalid vasriant type conversion".
Can anyone rescue me?
yomyom.

 

[michaenh]

"Invalid Variant Type Conversion".

Some fields in your table have been assign a different value from your Delphi application as it should.

ex.
Name is varchar but you have assigned in Delphi as this:
'Name' := 123;

mha