in form query - no results

[TonyK]

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.

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

[Kaptan]

You have to pass the arguments as an array.

Code: Select all

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

[TonyK]

Many thanks, it works now!