SQL works on phone but not on Galaxy Tab 10.2

jddiven · Apr 17, 2012

I've been trying to revamp the SQLExample tutorial program to work with my data and on both my phone and Samsung Galaxy Tab 10. What I've got so far works fine on the phone but when I run it on the Tab it works in the orientation that I start it, but when I switch orientation I get the message "an error has occurred in sub:main_activity_create(java line:395) android.database.sqlit.SQLiteDiskIOException: disk I/O error Continue?" If I continue the scroll bars will appear on each orientation shift but I get the same error message each time I switch orientation.

I'm baffled! Any suggestions would be appreciated.

Doug

jddiven · Apr 17, 2012

jddiven said:
I've been trying to revamp the SQLExample tutorial program to work with my data and on both my phone and Samsung Galaxy Tab 10. What I've got so far works fine on the phone but when I run it on the Tab it works in the orientation that I start it, but when I switch orientation I get the message "an error has occurred in sub:main_activity_create(java line:395) android.database.sqlit.SQLiteDiskIOException: disk I/O error Continue?" If I continue the scroll bars will appear on each orientation shift but I get the same error message each time I switch orientation.

I'm baffled! Any suggestions would be appreciated.

Doug

Sorry but I left this file off of the first post.

NJDude · Apr 17, 2012

You should post the source code not the APK to take a look at what you are doing.

From the IDE, click on File -> Export as ZIP

jddiven · Apr 18, 2012

Sorry

Sorry,

I know better. Guess I was more frazzled than I thought.

I will post that file tomorrow. For what it's worth, however, I've attached an earlier example that is not too far removed from the original SQLExample that exhibits the same behavior -- it's just not as pretty!

Thanks for your help!

Doug

NJDude · Apr 18, 2012

In line #4 you have:

B4X:

DBFileName = "mydata2a.db"

However, there's no "mydata2a.db" in your assets directory.

jddiven · Apr 18, 2012

Three's a charm

Sorry again.

This one is the original example without any changes whatsoever. It's database is persons.db and is in the file folder.

It still has the same problems with the Galaxy Tab.

I'm sorry for the false starts and appreciate your patience.

Thanks

NJDude · Apr 18, 2012

You should move these out of Activity_Resume

B4X:

Dim curs As Cursor
curs = SQL1.ExecQuery("SELECT name FROM sqlite_master WHERE Type='table'")
Log(curs.RowCount)
curs.Position = 0
Log(curs.GetString("name"))
DBTableName = curs.GetString("name")
' reads the database
SQLTableRead

jddiven · Apr 18, 2012

To Where?

When I move it to Activity Create I get the same problem. Where are you moving it to?

jddiven · Apr 18, 2012

Problem Solved

The original SQLExample contains the following line in the Activity_Create sub.

File.Delete(DBFileDir, DBFileName) used for testing, deletes the existing database

When I comment that line the program runs on both my phone and Galaxy Tab.

SQL works on phone but not on Galaxy Tab 10.2

jddiven

Member

Attachments

jddiven

Member

NJDude

Expert

jddiven

Member

Attachments

NJDude

Expert

jddiven

Member

Attachments

NJDude

Expert

jddiven

Member

jddiven

Member

Similar Threads

SQL works on phone but not on Galaxy Tab 10.2

Member

Attachments

Member

Expert

Member

Attachments

Expert

Member

Attachments

Expert

Member

Member

Similar Threads

Privacy & Transparency

Privacy & Transparency