Android Question Error with SQLite

This is my code to open the database
<code>

If File.Exists(File.DirDefaultExternal, "lototouch.db") = False Then
Log("Copiando la base de datos")
File.Copy(File.DirAssets, "lototouch.db", File.DirInternal, "lototouch.db")
Else
Log("La bas e de datos existe..")
End If
'
If File.Exists(File.DirInternal, "lototouch.db") = True Then
Log("La base de datos existe////..")
Else
Log("La base de datos NO existe..")
End If

Log("Dir Assets:" & File.DirAssets)
Log("Dir External:" & File.DirInternal)
Log("Dir External:" & File.DirDefaultExternal)
'
SQL.Initialize(File.DirDefaultExternal,"lototouch.db", True)
'
Dim av As String
av = SQL.ExecQuerySingleResult("Select count(*) from sqlite_master where Type = 'table' and name='t_ganadores';")
Log("AV::::" & av)
'
SQL.ExecNonQuery("DELETE FROM t_ganadores")
'
SQL.ExecNonQuery("DELETE FROM t_jugadas")
</code>

Change:
File.Copy(File.DirAssets, "lototouch.db", File.DirInternal, "lototouch.db")

TO
File.Copy(File.DirAssets, "lototouch.db", File.DirDefaultExternal, "lototouch.db")

Regards,

Edgar

Edgar, it works! but really I dont know how!! I dont understand because the database was in the other location , can you explain me how ?

This line opens the database:

mrjaw said:

Edgar, it works! but really I dont know how!! I dont understand because the database was in the other location , can you explain me how ?

Click to expand...

In your code you copy the database to Internal: File.Copy(File.DirAssets, "lototouch.db", File.DirInternal, "lototouch.db")
But you try to open it somewhere else: SQL.Initialize(File.DirDefaultExternal,"lototouch.db", True)
If you want to copy the database to internal, you need to initialize it in internal like this:
SQL.Initialize(File.DirInternal,"lototouch.db", True)