Updating game with modified table

pokapola

I am working on an update for my already published game. In the published version, I had tables, and for every one of them, I did make extra columns as I knew that I would need them for my future update (which I am working on right now).

One thing I did forget to do in the published game, was, to change the type of the columns and they stayed with "text" instead of "integer" or "real". And when I modify the type of the extra columns (to "integer" and "real") in the update I'm working on, it does not work.

Is there a way to change the type of the columns in an already existing table? Or is it not possible?

BigDave

your game update will break if you modify (add rows(columns)) an existing table that has been saved.

You can change tables which store data but are not saved on the device.

If you have to add more things to save you have to add a new table.

pokapola

@BigDave Thought so, I guess I have to make new tables. But just to clarify, adding only rows (not columns) should work right? Because I think I read that somewhere in the forum.