I am using a sql to store user horses in my app. I am using in activity load :
B4X:
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