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
Printable View
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) ?Quote:
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
thats not a valid field type, is it?
hi,
i thought C(4) stands for field type character and field length = 4. What should i use?
Try char(4) or varchar(4)
Best regards
yes, it already worked! thanks a lot