InfoPath Dev

It does, Thank you. I will give this a try and see what I can do. Thanks again. 

 Let me see if I understand correctly. Keep my WHERE clause and make the Data connection. Then save the form and use it a xml source file for a data connection in a new form? When you say remove it from the manifest do you mean removing the WHERE clause from the xml source file?

 Still couldn't find a "Show IP" option and the TOP(x) isn't working either. I'm using a WITH statement to create multiple "temp tables" and with a WHERE clause it runs incredibly fast. Without it, it's querying the entire db. I just need to get the connection made then the ModifySql command will keep my ...

I don't recall the show ip option. I will recreate the connection and look for it closer.  About the "TOP(x)" I can attempt it, but I don't believe it will do me any favors as the data sets can vary greatly and since I am not filtering with my where til in the form it's still going to cycle through a project list. Which ...

 This is in IP 2010. sorry meant to put that in there. SQL 2008 r2 is the DB im pulling from.

Hey Everyone. I am creating a Database Form and am attempting to add a secondary data connection. I have a SQL query that timesout on the initial creation of the connection when I attempt to "Test connection" or hit "Next" after editing the SQL command. Normally I would add a where clause into the query and limit its size to ...