New update: The database is being copied, but apparently not completely. If I access a different table, the query (same, except for the table name) works and I get the correct data. Oddly enough, Eclipse's debugger still says that table doesn't exist:
12-06 14:01:20.290: E/SQLiteLog(7927): (1) no such table: hopcountries yet it reads it and gets the right data.... However, the table I was trying to access gets the same error about it not existing, along with other error messages about column one not existing. I checked the source table again, and it's fine. The database is only 150k, so what could cause it to not be completely copied? I just did another experiment: I grepped for the Log.i lines I added for every 1024 byte block copied while copying the database, and wc -l says that there were 294 1024 byte blocks copied; multiply that by 1024 and it's 301056, which when divided by two is the correct size for the database, 150528. My memory regarding block size and such on Unix filesystems is a bit ancient (and missing right now thanks to chemobrain), but that's not a coincidence. So one problem says the database is NOT being copied completely while another non-error set of Log data says it is. I'm doing a byte by byte copy from assets to DB_PATH, as the tutorials I've seen all do. Is there a better way, or have I missed something? Why are tables showing up as not existing, when in some, the data IS there, and in others, it isn't (or is it?), and causes a force close if you try to access it? Thanks, --jim -- THE SCORE: ME: 2 CANCER: 0 73 DE N5IAL (/4) | "You didn't win the war by dying for your [email protected] | country. You won it by making some other < Running Mac OS X Lion > | poor dumb bastard die for his." ICBM / Hurricane: | 30.44406N 86.59909W | --Gen. George S. Patton -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en --- You received this message because you are subscribed to the Google Groups "Android Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
