Android Question How to get my database in File rahter than Tablet/Iphone memory?

[Itila Tumer]

I have problem with saving into File , I use IDE and sending to Tablet SQLiteLight2 made by Klaus . It save into the Tablet memory. But How could I change that. saving into where my program is and into the File. Do I need to give any dir?

Sub Activity_Create(FirstTime As Boolean)
  If FirstTime Then
    ' File.Delete(File.DirInternal, "persons.db") ' only for testing, removes the database
    If File.Exists(File.DirInternal, "persons.db") = False Then
      File.Copy(File.DirAssets, "persons.db", File.DirInternal, "persons.db")
      SQL1.Initialize(File.DirInternal, "persons.db", True)
      File.Copy(File.DirAssets, "persons.db", File.DirInternal, "persons.db")
    Else
      SQL1.Initialize(File.DirInternal, "persons.db", True)
    End If
  End If
 
  Activity.LoadLayout("Main")
  Activity.Title = "SQLiteLight2"
End Sub

 

[margret]

You can ty:

Sub Activity_Create(FirstTime As Boolean)
    If FirstTime Then   
        ' File.Delete(File.DirInternal, "persons.db")
        ' only for testing, removes the database
        If Not(File.Exists(File.DirInternal, "persons.db")) Then
            File.Copy(File.DirAssets, "persons.db", File.DirInternal, "persons.db")
        End If
        'Check For Update File
        If File.Exists(File.DirInternal, "personsupdate.db") Then
            File.Copy(File.DirAssets, "personsupdate.db", File.DirInternal, "persons.db")
        End If
    End If
    SQL1.Initialize(File.DirInternal, "persons.db", True)
    Activity.LoadLayout("Main")
    Activity.Title = "SQLiteLight2"
End Sub

 

[klaus]

Sorry, but I don't understand what exactly you want to do ?

 

[Erel]

It is not possible. The emulator uses its own file system. It cannot write to Windows file system.

 

[Itila Tumer]

Thanks for useful information Erel