to dear all, I just found a same open problem as the one I met: http://groups.google.com/group/android-developers/browse_thread/thread/84d7cf7f5106ef01/bc06bdd192a164e7?lnk=gst&q=database+reference#bc06bdd192a164e7
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 -~----------~----~----~----~------~----~------~--~---
