More information: The "_id" column brings no trouble as an ORDER BY argument, but can not exist in the projection map. The reason is still unknown.
Needs help, please. Sincerely, Nicholas On 2月13日, 上午10時32分, yukinoba <[email protected]> wrote: > 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 [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 -~----------~----~----~----~------~----~------~--~---
