Hi everyone, I met an issue when I tried to execute the select statement with the limit cause. I appended the offset value to the limit cause as the parameter for the SQLiteDatabase.query(), just as "10 offset 0", but it threw an exception on running time. I traced the source code, and found that Android appends a character '\'' at the beginning and end of the cause, so that the whole select statement becomes "select ..... from table where ... limit '10 offset 0';". This caused sqlite to return the error "SQL error: datatype mismatch".
My question is whether Android supports the offset option for limit cause? And how to deal this case in Android? Thanks & Best Regards, Stanley --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Beginners" 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-beginners?hl=en -~----------~----~----~----~------~----~------~--~---
