I have a InfoPath form that I need to create a connection to a SQL database and return some values. I can create with using the Data Connection wizard, but that returns too many records. What I want to do is to pass a parameter. Here is my current code.
function RetreiveMatters::OnClick(eventObj)
{
var objADOAdapter;
objADOAdapter = XDocument.DataObjects("matters").QueryAdapter ;
XDocument.objADOAdapter.Command = "exec _get_Lookup_values @table = 'matter', @filter = 'c.client_code = ''012307'";
//Query the Data Source.
XDocument.Query();
}
What Am I doing Wrong?
TIA
O
...If God didn't want us to eat animals, why did he make them out of meat???!!!