Android Question How do you find the sqlite datatype of a database column?

[zombee81]

Is there anyway to find the datatype of a column in an sqlite database from B4A?

 

[zombee81]

Sorry, found it now!

Simply use PRAGMA table_info( table_name );

 

[zombee81]

Found a problem with this, in that it doesn't return the AI state of the column, is there anyway to find out whether the column is autoincrementing?

 

[Erel]

Try this: http://stackoverflow.com/questions/20979239/how-to-tell-if-a-sqlite-column-is-autoincrement

 

[zombee81]

Thanks Erel! You're amazing as always. You truely are a god amoung mortals.