jeudi 19 février 2015

How to update list of records with special characters into sqlite table using ormlite in Android

I am using ormlite for database operations in my Android app. I want to update around 1000 records at a time. But, if these records have any special characters such as ' / \ % , I am getting the following exception.



java.sql.SQLException: Problems executing Android statement: UPDATE `staticresource` SET `Content` = 'Tick next to member and add by clicking on \'Invite Selected\' button to create invite list.' ,`Id` = '3' WHERE `Alias` = 'tm'


So, how to update these records optimally. Thanks in advance.


Aucun commentaire:

Enregistrer un commentaire