Don Roberts Member Licensed User Dec 29, 2015 #1 Is it possible to change a column's data type. Specifically from integer to string. Details: I had the column storing the spinners index as an integer, on program launch the spinner was assigned the index from this value. (faster than looping through all the values) I would now like to store the spinners actual text at the index. (forgot that I may need to add additional items [into the middle of the items] changing the index numbers)
Is it possible to change a column's data type. Specifically from integer to string. Details: I had the column storing the spinners index as an integer, on program launch the spinner was assigned the index from this value. (faster than looping through all the values) I would now like to store the spinners actual text at the index. (forgot that I may need to add additional items [into the middle of the items] changing the index numbers)
Erel B4X founder Staff member Licensed User Longtime User Dec 30, 2015 #2 It is not possible to change the column type in SQLite. However you can store strings in a numeric column. The types are not enforced. Upvote 0
It is not possible to change the column type in SQLite. However you can store strings in a numeric column. The types are not enforced.
