<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Data Connections</title><link>https://www.infopathdev.com:443/forums/44.aspx</link><description> </description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: Edit SQL in InfoPath Data Connection wizard</title><link>https://www.infopathdev.com:443/forums/thread/41632.aspx</link><pubDate>Wed, 13 May 2009 05:23:19 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:41632</guid><dc:creator>Patrick Halstead</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/41632.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&amp;PostID=41632</wfw:commentRss><description>&lt;p&gt;No. Passing parameters isn&amp;#39;t supported. It&amp;#39;s why we developed our Database Accelerator which is a Web Service that supports passing parameters. Free download available here: &lt;a href="http://www.qdabra.com/en/products/DBXL.aspx"&gt;http://www.qdabra.com/en/products/DBXL.aspx&lt;/a&gt;&amp;nbsp;&lt;/p&gt;</description></item><item><title>Edit SQL in InfoPath Data Connection wizard</title><link>https://www.infopathdev.com:443/forums/thread/41628.aspx</link><pubDate>Wed, 13 May 2009 04:44:08 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:41628</guid><dc:creator>ramakrishna</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/41628.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&amp;PostID=41628</wfw:commentRss><description>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?
&lt;br /&gt;
For example:
&lt;br /&gt;

select &amp;quot;Title&amp;quot;,&amp;quot;Office&amp;quot; from &amp;quot;dbo&amp;quot;.&amp;quot;Title&amp;quot; as &amp;quot;Title&amp;quot; where Office = 

I&amp;#39;m not sure if  can be substitude by a parameter field that InfoPath would accept.</description></item></channel></rss>