SQL works on phone but not on Galaxy Tab 10.2

[jddiven]

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]

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]

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]

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]

In line #4 you have:

DBFileName = "mydata2a.db"

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

 

[jddiven]

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]

You should move these out of Activity_Resume

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]

To Where?

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

 

[jddiven]

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.