I have an app out on the Android market that user data is stored in SQLite. I created a database table with a column of ints. I would like to store floats there now. How can I do this? When I try to insert a float, my app seems to throw an exception.
As SQlite doesn't implement full support for
ALTER TABLE (only renaming a table and adding a column), you'll have to:
INSERT INTO tmp SELECT * FROM orig