Newbie Questions

Re: Pass a form field value to a secondary datasource as a paramater

Hilary Stoupa — Fri, 10 Jan 2014 22:39:18 GMT

Excellent! I just realized that the MSDN sample was also needing to query for a specific employee Id. :)

Re: Pass a form field value to a secondary datasource as a paramater

moneyhan — Fri, 10 Jan 2014 22:28:08 GMT

Thank you very much! That actually did the trick.

Re: Pass a form field value to a secondary datasource as a paramater

Hilary Stoupa — Fri, 10 Jan 2014 20:23:28 GMT

I'm sorry to tell you your options here are limited - you can use a web service to return just the data you need (custom, DBXL, etc.). You could use qRules - it can add a "where" clause with the ModifySqlQuery command - or you can write code - here's an MSDN link that might help there:

IP 2007 - http://msdn.microsoft.com/en-us/library/office/microsoft.office.interop.infopath.semitrust.adoadapterobject.aspx

IP 2010 / 2013 - http://msdn.microsoft.com/en-us/library/office/microsoft.office.infopath.adoqueryconnection.command.aspx

Pass a form field value to a secondary datasource as a paramater

moneyhan — Fri, 10 Jan 2014 20:15:55 GMT

Hi Everyone,

Sorry if this has been answered a hundred times and I just couldn't find it..

I am querying a record set in SQL server that is over 50,000 records. Needless to say, if I can't pass a parameter (employeeID in this case) to get the specific record I am looking for the performance is terrible. I am hoping there is a way to use a SQL secondary data source with a parameter to avoid the overhead. I have not been able to find anything. I am hoping to do it without code as I am not an up to date programmer (Classic ASP is where I stopped). I also don't think I have the option of a Web Service either.

Thanks in advance.