The following is triggered by a button OnAction event, but my form doesn't refresh with the results. Am I missing something or doing something wrong?
I've left in a commented version of the query which I started with.
- Code: Select all
//var _sQuery = "SELECT unq_id FROM trunk WHERE cast(trunkno, 'string') LIKE ? OR trunkname LIKE ?"; // pseudo sql
var _sQuery = "SELECT unq_id FROM trunk WHERE trunkno LIKE ? OR trunkname LIKE ?"; // pseudo sql
var _sArg = "%" + globals.SrchFor + "%";
controller.loadRecords(_sQuery, _sArg, _sArg);
Any help appreciated.
Tony