Android Question sql file

[tufanv]

Hello,

I am using a sql to store user horses in my app. I am using in activity load :

    If File.Exists(File.DirInternal,"userhorses.sql") = False Then
        File.Copy(File.DirAssets,"userhorses.sql",File.DirInternal,"userhorses.sql")
    End If
   
    If sqluserhorses.IsInitialized = False Then
        sqluserhorses.Initialize(File.DirInternal, "userhorses.sql", False)
    End If

Now i want to add a new function to game so i added a new coloumn to sql but because of the above code the app do not copy the new sql ( this is true i dont want to copy the new sql because then all the previous horses would be deleted) so i cant use the new added coloumn. How can I overcome this ? any ideas

 

[LucaMs]

You should use the sql command ALTER TABLE http://sqlite.org/lang_altertable.html

but in the db file that is in the File.DirInternal

 

[Erel]

The solution is to store the version information in the database. There is an example here: DBUtils - Android databases are now simple!