To dear all, I found that when you use "_id" column as the projection map and the order-by value, the query will stuck and never return. However, there has another problem still blocks me to return back from the query method.
Please, I need more information and help. Sincerely, Nicholas On 2月12日, 下午4時15分, yukinoba <ckmagic...@gmail.com> wrote: > Hi all, > > More information found: > The database could be written by the execSQL method, however, it could > not be read from the query method. > > A "Write-Only" database? that's weird... > > I open my database with SQLiteDatabaseHelper and SQLiteDatabase as > below: > > mDbHelper = new DatabaseHelper(mCtx); > mDb = mDbHelper.getWritableDatabase(); > > Is it possible that the read-access is "locked" by the first database? > I'm sure that I close my database with mDbHelper.close() after each > query... > > On 2月12日, 下午4時00分, yukinoba <ckmagic...@gmail.com> wrote: > > > to dear all, > > > I just found a same open problem as the one I > > met:http://groups.google.com/group/android-developers/browse_thread/threa... > > > Hope this could help > > > Any suggestions and ideas are welcome, Plz :-) > > > Best regards, > > Nicholas > > > On 2月12日, 下午2時49分, yukinoba <ckmagic...@gmail.com> wrote: > > > > I have a new question for this: > > > > Can there have multiple databases created in the same application or > > > service? > > > I have 2 databases, one for query and store the information about > > > phone numbers, and one for the names. > > > However, the ealier one works fine, and the later one stucks in the > > > method and never get rid of that status. > > > > So, my question is, does each application / service have been limited > > > to have only one single database? > > > > Plz provides any help or suggestion > > > > Best regards, > > > Nicholas > > > > On 2月12日, 上午9時23分, yukinoba <ckmagic...@gmail.com> wrote: > > > > > Could someone give a little bit information about any possible > > > > solution or hint? > > > > I have searched in this forum and nothing about this topic :-( > > > > > On 2月11日, 下午6時44分, yukinoba <ckmagic...@gmail.com> wrote: > > > > > > More information: > > > > > > Most of the data (surname) here are utf-8 encoded, does this cause the > > > > > error? > > > > > Could anyone tell me how to push an utf-8 String in the SQL statement? > > > > > > Thanks for any help! :-) > > > > > > Best regards, > > > > > Nicholas > > > > > > On 2月11日, 下午5時18分, yukinoba <ckmagic...@gmail.com> wrote: > > > > > > > to dear all Android developers, > > > > > > > I'm dealing with database operation on Android recently. > > > > > > However, there has a problem troubles me that the query method in > > > > > > SQLiteQueryBuilder infinitely loops and has no return. > > > > > > > The operation code is like below: > > > > > > > //------------ CODE section --// > > > > > > SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); > > > > > > > qb.setTables(TABLE.NAME); > > > > > > qb.setProjectionMap(TABLE.ProjectionMap); > > > > > > qb.appendWhere(TABLE._ID + "=" + id + " AND " > > > > > > + TABLE.SURNAME + "='" + surname + "'"); > > > > > > > String orderBy = TABLE._ID + " ASC"; > > > > > > String[] projection = new String[] { > > > > > > TABLE._ID > > > > > > > }; > > > > > > > mDbHelper = new DatabaseHelper(mCtx); > > > > > > mDb = mDbHelper.getWritableDatabase(); > > > > > > > Cursor c = qb.query(mDb, projection, null, null, null, null, > > > > > > orderBy); > > > > > > //------------ CODE section --// > > > > > > > However, it stuck in the query and never return back, and there has > > > > > > neither exceptions nor any error messages from the LogCat. Does > > > > > > there > > > > > > any mistake I make in my code? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
