android-sqlite
Reopen SQLiteOpenHelper when my application is stopped as "close()" was never explicitly called on database"
I\'m using the SQLiteOpenHelper. When my application is normally closed, the database is closed normally in the method onDestroy(), too. When it\'s force closed, the database is left open and later, w[详细]
2023-04-07 22:24 分类:问答Convert an SQL expression if it has a LENGTH function with SUBSELECT query to SQLite
I know that in SQLite, we use the LENGTH function instead of len. But when I want to use the LENGTH function with a subquery like so:[详细]
2023-04-06 22:56 分类:问答When should I close the DatabaseHelper?
With reference to this link, when is a good time to close the connection if you only have one connection? I have 开发者_JAVA百科a service running in the background at all times. When is a good time to[详细]
2023-04-04 23:16 分类:问答get data from sqlite into edittext based on condition provided
I am working on an Android project where I am struck with a issue. I need to fetch data from SQLite db based on condition provided.[详细]
2023-04-04 15:46 分类:问答Disallow duplicate records and check if database is available
I am creating a database and I\'m inserting a row like so: /* Add two DataSets to the Table. */ myDB.execSQL(\"INSERT INTO \"[详细]
2023-04-03 09:08 分类:问答Add value from Array to an XY Series
I want to add a value from SQLite to an XY series to create a diagram. Here is what I\'ve done so far:[详细]
2023-03-31 16:09 分类:问答Error displaying database within a ListView
I am displaying my database in a ListView. I used a Button named find geopoint for displaying the database. when I click on it, the application crashes. Here is the stack trace:[详细]
2023-03-30 11:50 分类:问答SQLite query keeps crashing
I have this query that returns a particular record based on some parameters passed within a form in my application. This is where I get the problem:[详细]
2023-03-30 02:42 分类:问答Tapping on Map Marker results in AlertDialog displaying all other Map Markers
I have a description column in my SQLite database that contai开发者_开发问答ns some text to display when taping to every marker. Every marker has its own description. The problem is when I tap on one[详细]
2023-03-29 22:33 分类:问答SQLiteDiskIOException with error code 10: disk I/O error
I moved an SQLite database to an SD card, but sometimes it will throw the following exception: android.databas开发者_Go百科e.sqlite.SQLiteDiskIOException: error code 10: disk I/O error[详细]
2023-03-27 04:58 分类:问答