Z zombee81 Member Licensed User Longtime User Jul 18, 2014 #1 Is there anyway to find the datatype of a column in an sqlite database from B4A?
Z zombee81 Member Licensed User Longtime User Jul 18, 2014 #2 Sorry, found it now! Simply use PRAGMA table_info( table_name ); Upvote 0
Z zombee81 Member Licensed User Longtime User Jul 18, 2014 #3 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? Upvote 0
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 B4X founder Staff member Licensed User Longtime User Jul 18, 2014 #4 Try this: http://stackoverflow.com/questions/20979239/how-to-tell-if-a-sqlite-column-is-autoincrement Upvote 0
Try this: http://stackoverflow.com/questions/20979239/how-to-tell-if-a-sqlite-column-is-autoincrement
Z zombee81 Member Licensed User Longtime User Jul 18, 2014 #5 Thanks Erel! You're amazing as always. You truely are a god amoung mortals. Upvote 0