B4J Question Add Col/Field in Sqlite

[TomDuncan]

Hi,
I need a way of checking if a field exists in a table, then
if not add it.

Tom

 

[Erel]

You can use PRAGMA table_info: http://www.sqlite.org/pragma.html#pragma_table_info

And then ALTER TABLE: http://www.sqlite.org/lang_altertable.html

 

[TomDuncan]

Just Had a look at Rob's Howto on Sqlite. "List Database Tableinfo"
Will modify that and then use the Alter table as you suggest.
Tom