Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 1 of 1 (3 items) Re: Submit to Sql, Query for Auto ID, Use it in submit to sharepoint library I figured out what I had done. I created the data connections and converted them to .udcx but forgot to them remove that and add the .udcx back to the project. All is well now....thanks Clay. Posted to SQL Database Integration (Forum) by rimbaugk on 06-10-2008 Re: Submit to Sql, Query for Auto ID, Use it in submit to sharepoint library Thanks Clay. It works in Infopath, but I still must be doing something wrong on the browser side. I defined a data connection and added the SQL to it for Max(). Then I used the field when I submit to sharepoint to set it as the filename. When you say move the unique id to the form.....that might be what I'm screwing up ... Posted to SQL Database Integration (Forum) by rimbaugk on 06-09-2008 Submit to Sql, Query for Auto ID, Use it in submit to sharepoint library I could use a little help with the syntax required to pull this off. I'm am working with Project Requests. I have an InfoPath form that submits data to a sql database. Upon submit a unique id is generated in the SQL table which serves as my Project Request ID. The ID field isn't in my web service. Then I want to query that ... Posted to SQL Database Integration (Forum) by rimbaugk on 06-06-2008 Page 1 of 1 (3 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.