Android Question Regenerate/copy DB file

[daniedb]

HI Guys

I have this code in activity_create

        If File.Exists(File.DirInternal,"tx.sql") = False Then
           File.Copy(File.DirAssets,"tx.sql",File.DirInternal,"tx.sql")
         End If

this will copy the file if not exists and allow the user to update records
I've changed the tx.db and add a new table.

Now the program won't copy it again, because it already exists.

So my work around were this:

    If File.Exists(File.DirRootExternal,"dbflag.txt")=True Then
         If File.Exists(File.DirInternal,"tx.sql") = False Then
           File.Copy(File.DirAssets,"tx.sql",File.DirInternal,"tx.sql")
         End If
       Else
         File.WriteString(File.DirRootExternal, "dbflag.txt","")
         File.Copy(File.DirAssets,"tx.sql",File.DirInternal,"tx.sql")
        End If
    End If

Which means a new DB is copy, AND all the users data has been erased with a new db

What better way is there to use new tables added to DB, and create that tables without erase previous data

Thanks, appreciate
Danie

 

[Erel]

Please use [ code ] [ /code ] tags (without spaces) when posting code.

It is not a simple problem. You need to copy the new database from the assets folder. Open both databases and merge them.

http://www.b4x.com/android/forum/threads/how-to-attach-2-databases-and.31075/#content

 

[daniedb]

Thanks Erel, Post Fixed. Sorry about that. Need to learn the rules
Cheers
Danie

 

[LucaMs]

You could also use this code to check if a table exists:

Public Sub TableExists(DB As SQL, TableName As String) As Boolean
    Private Query As String
    Private Cur As Cursor
  
    Query = "SELECT Name FROM sqlite_master WHERE type = 'table' AND Name =?"
  
    Cur = DB.ExecQuery2(Query, Array As String(TableName))

    Return (Cur.RowCount >= 1)
End Sub

 

[daniedb]

Thanks LucaMs. I'll give it a try

Cherio
Danie