InfoPath Dev

 Jimmy, can you revisit this with a bit simpler example please? I don't have the nested repeating fields, but still want to remove any duplicates. My aggregate formula looks like this: substring((eval(eval(FieldName, 'concat(., "; ")'), "..")), 0, (string-length(eval(eval(FieldName, 'concat(., "; ...

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

I am suggesting that when you create the data connection in your InfoPath form template, you include the Where clause by clicking the Edit SQL button in the data connection dialog that generally shows the SQL data structure tree. Set the data connection to not run on load.  Then save your form as source files (from the Publish ...

 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?

By "IP" I meant InfoPath - the button itself shows the SQL InfoPath is using. What I'm trying to suggest is a way to get the form to let you set up the data connection - my understanding of your description was that the form is timing out when you try to create the data connection.  But it sounds like you are already directly ...

 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 ...

When you initially create the data connection to SQL there should be a button in one of the dialogs that you can click to show the actual SQL IP is using. I'm wondering about adding a "top x" to the query - do you have an idea of the max number of rows your ModifySQLQuery command might return? You could probably limit the results ...

 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 ...