Newbie Questions

Re: Edit SQL in InfoPath Data Connection wizard.

Hilary Stoupa — Mon, 23 Mar 2009 16:58:33 GMT

Well, you could add an XML file with all your Offices, and then just filter the data you show in the form, if that is what you mean. What is your desired end result?

Re: Edit SQL in InfoPath Data Connection wizard.

In2Moss — Sat, 21 Mar 2009 19:24:26 GMT

Would it be possible with XML instead? If yes, what should I look for?

Re: Edit SQL in InfoPath Data Connection wizard.

Hilary Stoupa — Sat, 21 Mar 2009 12:03:02 GMT

No, I'm sorry, but for your SQL Query to use form information, you'll need to add code to modify the query.....

Edit SQL in InfoPath Data Connection wizard.

In2Moss — Fri, 20 Mar 2009 20:33:39 GMT

While using Edit SQL in InfoPath Data Connection wizard.
Can a where clause in the Edit SQL in the data connection wizard in InfoPath takes a value from myFields/my:OfficeTitle?

For example:

select "Title","Office" from "dbo"."Title" as "Title" where Office = <OfficeTittle>

I'm not sure if <OfficeTittle> can be substitute by a parameter field that InfoPath would accept.