SQLite DB error

[JonPM]

I have an app near completion. It contains a SQLite database with one table named "main". Everything works corrects on my HTC Rezound, but when I put the app on my DroidX I get the following error:

android.database.sqlite.SQLiteException: no such column:FirstName: , while compiling: SELECT FirstName, LastName FROM main ORDER BY FirstName

For a fact the columns exist (and as proof everything works perfectly fine on my HTC), so why doesn't it work on the DroidX?

This is my first app using SQLite db. Are there any known compatibility issues with android?

 

[poseidon]

re

try to move the dbase to dir.DirDefaultExternal and postback the results.

moreover
http://www.b4x.com/forum/basic4andr...als/6808-error-writing-sd-card-how-solve.html

 

[Erel]

How are you copying the database?

 

[JonPM]

How are you copying the database?

If FirstTime Then
      If File.Exists(File.DirInternal, DBFileName) = False Then
         DBFileDir = DBUtils.CopyDBFromAssets(DBFileName)
      End If
      SQL1.Initialize(DBFileDir, DBFileName, True)
...

DBFileDir = File.DirInternal

 

[poseidon]

re

try dir.DirDefaultExternal

--

something similar.
android copying database from internal to external storage return empty database - Stack Overflow

 

[JonPM]

I wonder if it is because the app gets installed to sdcard? I will try disabling this when I get home tonight.

 

[klaus]

Looking at the CopyDBFromAssets routine you'll see that it copies the database to the DirDefaultExternal folder if possible otherwise to File.DirInternal.

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

Best regards.

 

[JonPM]

Thanks klaus, that must be it. Will report back.

 

[JonPM]

Another question. Since I don't plan on modifying the db at all from within the app, should I just keep it in DirAssests? Would that affect performance at all? would that interfere with commands like sort?

 

[klaus]

No, you can't access a database in File.DirAssets !

Best regards.

 

[JonPM]

That answers that