Android Question DirInternal sqlite

[sigster]

Hi
I was using DirRootExternal for the SQLite file with no problem now I change into DirInternal.

Sometimes when I open the app I don't get the data from SQLite file I need to open and close the app few time
until I get the date from SQLite file , It happens very often

    If FirstTime Then
        
        If File.Exists(File.DirInternal, "color.db") Then
            Log("File OK")
            SQL1.Initialize(File.DirInternal, "color.db", False)
        Else
            File.Copy(File.DirAssets,"color.db",File.DirInternal,"color.db")
            Log("File Missing")
            SQL1.Initialize(File.DirInternal, "color.db", False)
        End If
    End If

        Dim Cursor1 As Cursor
    Cursor1 = SQL1.ExecQuery("SELECT * FROM category ORDER BY category_name")   
    For i = 0 To Cursor1.RowCount - 1
        Cursor1.Position = i
        CLV1.AddTextItem(Cursor1.GetString("category_name"), Cursor1.GetString("category_name_ID"))
    Next
    Cursor1.Close

 

[Erel]

Better:

  If FirstTime Then
        If File.Exists(File.DirInternal, "color.db") Then
            Log("File OK")
        Else
            File.Copy(File.DirAssets,"color.db",File.DirInternal,"color.db")
            Log("File Missing")
        End If
         SQL1.Initialize(File.DirInternal, "color.db", False)
    End If

Your code looks correct. The problem is somewhere else.

 

[sigster]

Thanks will check the app better