in form query - no results

Classic Servoy
1

I need to query a Foxpro table where the two columns being searched are different data types, one an integer the other a string. Having searched the forum I found something that looked very much like what I was trying to do and yet I do not seem to get any results appearing in my form.

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.

	//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

2

You have to pass the arguments as an array.

controller.loadRecords(_sQuery, [_sArg, _sArg]);
3

Many thanks, it works now! :D