I know the C.IsInitialized code is not needed, this was one of the unsuccessful things I tried. Q = "Select * from RaceresultsStatusTypes where Type = '" & ResultStatusType & "'"Ĭ.Position = 0 ' this is the line it failed on Sub GetResultStatusID(ResultStatusType As String) As Int ** Activity (events) Create, isFirst = true **Ī: disk I/O error (code 1802)Īt .nativeExecuteForCursorWindow(Native Method)Īt .executeForCursorWindow(SQLiteConnection.java:845)Īt .executeForCursorWindow(SQLiteSession.java:836)Īt .fillWindow(SQLiteQuery.java:62)Īt .fillWindow(SQLiteCursor.java:143)Īt .getCount(SQLiteCursor.java:132)Īt (AbstractCursor.java:219)Īt $tPosition(SQL.java:322)Īt ._getresultstatusid(sqldata.java:1425)Īt ._createneweventbyimport(importexport.java:514)Īt ._mnuimport_click(events.java:1247)Īt .invoke(Native Method)Īt .runMethod(Shell.java:710)Īt .raiseEventImpl(Shell.java:342)Īt .raiseEvent(Shell.java:249)Īt 2(ShellBA.java:139)Īt $1.run(BA.java:325)Īt android.os.Handler.handleCallback(Handler.java:751)Īt android.os.Handler.dispatchMessage(Handler.java:95)Īt android.os.Looper.loop(Looper.java:154)Īt (ActivityThread.java:6123)Īt .ZygoteInit$n(ZygoteInit.java:867)Īt .ZygoteInit.main(ZygoteInit.java:757) ** Activity (main) Pause, UserClosed = false ** Also, during our research on databases CRUD acronym (Create. ** Activity (main) Create, isFirst = true ** We learned that SQLite functiones will be useful in further creation of an android application. Is this an issue caused by using SQLite on Android 7? Any solutions? Q = "SELECT * FROM RaceResults INNER JOIN Entrants ON RaceResults.EntrantId = Entrants.Id WHERE Entrants.Id = " & EntrantId It occurs at different points in the code. Other database commands do not cause the issue. The problem occurs when a cursor is used, after being created by an ExecQuery command. It happens running both version 6.8 and 7.3 of B4A It also runs correctly on an Amazon Fire. ![]() On a Nexus5 phone running Android 6 it runs perfectly. ![]() ![]() On a Motorola G5 running Android 7.1 get the problem. The code runs correctly most of the time but occasionally fails with a disk IO error - An error has occurred in sub:sqldata_setracepromotionnumber(Java line: 2359) :disk I/O error(code 1802) Continue no/yes For instance, Core Data abstracts away most of the SQL syntax and database normalization concerns facing database engineers every day. The error is intermittent and occurs at different point in my code. I am getting an error when accessing data from an SQLite database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |