Android Question Sqlite Append And Populate New Column

Sub SQLITEUPDATE
   sqlMainDatabase.ExecNonQuery( "ALTER TABLE TABLE_LANGUAGE ADD COLUMN COL1 TEXT")
 
sqlMainDatabase.BeginTransaction
  Try
     For i = 1 To 10
     sqlMainDatabase.ExecNonQuery2("INSERT INTO TABLE_LANGUAGE (COL1) VALUES (?)", Array As String("Lang"))
    Next
     sqlMainDatabase.TransactionSuccessful
   Catch
    Log(LastException.Message)
   End Try
  sqlMainDatabase.EndTransaction
End sub