how to add column

[tonio]

hi,

just want to ask how to add a column programmatically using ADO. Im trying to use the code below but it causes error.

dbconnTmp.Execute ("alter table table1 add column cd C(4)")

what's wrong with my code?

pls. help ..thanks in advance

[peet]

Originally posted by tonio
hi,

just want to ask how to add a column programmatically using ADO. Im trying to use the code below but it causes error.

dbconnTmp.Execute ("alter table table1 add column cd C(4)")

what's wrong with my code?

pls. help ..thanks in advance

what is C(4) ?

thats not a valid field type, is it?

[tonio]

hi,

i thought C(4) stands for field type character and field length = 4. What should i use?

[Joacim Andersson]

Try char(4) or varchar(4)

Best regards

[tonio]

yes, it already worked! thanks a lot