SQL problem (Problem with ALTER TABLE in VB6)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • farhad
    New Member
    • Sep 2006
    • 17

    SQL problem (Problem with ALTER TABLE in VB6)

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