Alter Table SQL String - Syntax error

Question

This is a bit of a two part question, firstly the SQL string

Dim Addcolumn As New OleDb.OleDbCommand("ALTER TABLE [" & TableName & "] ADD " & X & "", con)


    X = 0
    Do
        X = X + 1

        Addcolumn.ExecuteNonQuery() 
    Loop Until X = 8

This string is throwing up a syntx error, specifically OleDbException was unhandled, Syntax error is SQL statement

Im not sure where ive gone wrong, done some research but can't find a fault, im sure its obvious to someone with a bit more experience.

My second part of the question is clarification on something I was wondering. If I enter new columns into a data set will it stick when I update the form? Or is it only rows that do that? And if so will creating new columns in the actual table, then copying it to the dat set, then updating the table through a table adapter work? And give me my desired rows and columns for my table?

All help is greatly appreciated

Thanks so much in advance!

Moh =)

What query are you trying to run? ATM it's ALTER TABLE (TableName) ADD 1..2..3..4.. which isn't valid SQL syntax at all. — hkf
– hkf, Commented May 9, 2012 at 23:14
@hkf Im trying to create a new column everytime the loop completes. I,m guessing im nowhere near close then? — Mohjo
– Mohjo, Commented May 9, 2012 at 23:19

Gratzy · Accepted Answer · 2012-05-09 23:25:47Z

1

you can try

 X = 0
    Do
      Dim Addcolumn As New OleDb.OleDbCommand("ALTER TABLE [" & TableName & "] ADD COLUMN " & X      & " varchar(10) NULL", con)

        X = X + 1

        Addcolumn.ExecuteNonQuery() 
    Loop Until X = 8

edited May 9, 2012 at 23:25

answered May 9, 2012 at 23:18

Gratzy

9,4174 gold badges32 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alan Over a year ago

Up voted the question and response because the question was clearly phrased and just seeing the syntax answered my question. Thx!

Collectives™ on Stack Overflow

Alter Table SQL String - Syntax error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related