Android Question read PRAGMA table_info

[Alessandra Pellegri]

I should insert a column in a database if it doesn' exists.
I could do this:

try
  ALTER TABLE myTable ADD COLUMN test BOOL;
catch
'Do nothing
end try

But I would like to use a more clean solution testing if the column already exists. But how could I read the PRAGMA table_info results ?

Thank you

 

[mc73]

Tried this?

 

[eurojam]

you can do something like this:

   Dim cur As ResultSet
    cur = aSQL.ExecQuery("PRAGMA table_info(mytable);")
    Do While cur.NextRow
      Log(cur.GetString("name"))
    Loop

The field "name" contains the column names

 

[Alessandra Pellegri]

@mc73
Thank you, I am testing it now

@eurojam
I think that it works just in IOS and not in Android