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 -~----------~----~----~----~------~----~------~--~---
