VB6 and Create a field BY ADODB

[farhad]

Hi

Do you know , how can I use this SQL. in my VB form if the columnname not be fixed inside the project, (Column name is variable)

Conn.Execute "ALTER TABLE tablename ADD COLUMN columnname text"


Please dont forget that columnname is refer a textbox such as Text1.Text



and second :if I want to create a column with Number format (as single or integer) what shoud I write insted of TEXT ?


Thank you

[saravanankm]

Hi

This is Int,Integer,float sql datetypes U can Pass Any One of these...

Conn.Execute "ALTER TABLE tablename ADD COLUMN columnname int"

Thnaks,
Captain

[farhad]

Thank you so much ,saravanankm