Android Question Externally created database

Is it a SQLite DB?

Did you copy the DB from assets to a writable location?

Yes, It's SQLite DB.

Public Sub CopyDBFromAssets (FileName As String) As String
Dim TargetDir As String
If File.ExternalWritable Then TargetDir = File.DirDefaultExternal Else TargetDir = File.DirInternal
If File.Exists(TargetDir, FileName) = False Then
File.Copy(File.DirAssets, FileName, TargetDir, FileName)
End If
Return TargetDir
End Sub

I used this Sub from DBUTILS. Rethinking, I then tried to reference tables in File.DirInternal and File.DirExternal. Should I have used 'TargetDir' instead? (Eril's DBUTILS has the sub for copying files from ASSETS but doesn't use it in his sample program. He rebuilds tables instead...hence the confusion.

casher2 said:

Should I have used 'TargetDir' instead?

Click to expand...

After you copied the database to TargetDir you should use (initialize) the database in TargetDir. Correct.

Will try 'TargetDir'. Suspect this was my error and if it resolves issue, will save me tons of time and coding. Thanks!!