How to fetch single quoted(') value from db file using XMLHi all
I have a database file(.db) which contains 10 records and in that one record's column(account) is PF'LE*. I want to fetch this record using the condition account == PF'LE*.
I am doing this through xml
<Condition operator="EQUAL" version="6.2">
<Field name="account" visibility="Local" version="6.2" /><Value>PF'LE*</Value>
But i am not able to fetch the record, even tried ' and "''" .. Kindly help to fix this.