Android Question add new field to database after publication

Sub AddColumns
 
    If ColumnExist("MyTable", "NewColumn")=False Then
         SQL1.ExecNonQuery("ALTER TABLE MyTable ADD NewColumn NVARCHAR(20)")
    End If
 
   If ColumnExist(..........
        .......
   End If
 
End Sub
 
 
Sub ColumnExist(Table As String, ColName As String) As Boolean
   Dim Cursor1 As Cursor
   Dim Query As String
 
   Query="SELECT * FROM " & Table & " LIMIT 1"
   Cursor1 = SQL1.ExecQuery(Query)
   For i=0 To Cursor1.ColumnCount - 1
       Cursor1.Position = 0
       If Cursor1.GetColumnName(i)= ColName Then
          Cursor1.close
          Return True
       End If
   Next
   Cursor1.close
   Return False
End Sub

Sub check_add_field(cf As String, typ As String, table as String)
Dim R, qry As String
    Try
        qry="select " & cf & " from " & table & " LIMIT 1"
        R=sql1.ExecQuerySingleResult(qry)
        Log("CHECKED COLUMN " & cf & " " & R)
    Catch
        qry="ALTER TABLE " & table & " ADD COLUMN " & cf & " " & typ
        sql1.ExecNonQuery(qry)
        Log("ADDED COLUMN " & cf)
    End Try
End Sub