I have the following formula that works for me
Code: Select all
put "SELECT * FROM Finques WHERE finca LIKE '%" & pSearch & "%' OR municipi LIKE '%" & pSearch & "%'" into tQuery
put textDecode(revDataFromQuery(tab, cr, gDatabaseID, tQuery),"UTF-8") into tData
Result : C6C26524-7025-46D1-B93B-18889180031A FIN001 Aldea Mar Mollet
Code: Select all
put "SELECT * FROM Finques WHERE finca LIKE :1 OR municipi LIKE :1" into tQuery
put textDecode(RevDataFromQuery(tab, cr, gDatabaseID, tQuery ,"pSearch"), "UTF-8") into tData
Regards,
Carles