Android Question sql file

tufanv

Expert
Licensed User
Longtime User
Hello,

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
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…