https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/55096.aspxThu, 20 May 2010 05:47:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:55096Patrick Halstead0https://www.infopathdev.com:443/forums/thread/55096.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=55096<p>In the wizard for the SQL receive data connection, there should be an option for specifying the SQL Select Text.&nbsp;Double click the button and add a rule to query that data connection.</p>https://www.infopathdev.com:443/forums/thread/55069.aspxWed, 19 May 2010 17:47:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:55069Waldorf0https://www.infopathdev.com:443/forums/thread/55069.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=55069<p>I&#39;m brand new to InfoPath and VB. Can someone help me with the correct syntaxt to create my own query without breaking the data field bindings? I have one query field that I&#39;ll use to select a record(s) from a SQL databse. I want to modify the query so that I can format a date field to return formatted, retrieve all the rest of the fields and populate the InfoPath form accordingly. I know the SQL query statement to use in MSSQL but I don&#39;t know how to apply it to a button. </p> <p>&nbsp;Thanks in advance</p>