Data Connections

Re: Modify SQL query in data connection file (.udcx)?

mahakbhalla — Wed, 11 Aug 2010 05:38:59 GMT

Yes, this problem is solved. download a copy of UDCX file from your data connection library. Edit the query or what ever changes are required. upload the modified file back to data connection file library. It will be uploaded as new version and processing will be done according to your modified connection file.

Re: Modify SQL query in data connection file (.udcx)?

mahakbhalla — Thu, 29 Jul 2010 07:29:17 GMT

OK done, for future reference: I saved the source files and the endited the query in manifest file. It worked like charm.

update- but this wil work only when the dataconnection is NOT converted to .UDCX

Help to update query in .udcx file is still needed.

Modify SQL query in data connection file (.udcx)?

mahakbhalla — Thu, 29 Jul 2010 07:06:08 GMT

I have an issue, in my infopath form, there is a dataconnection that receives data from SQL server and fills up a drop down. I have converted that data connection to data connection file (.udcx) as a relative link to site collection. This data connection is refered at many locations in form.

My question is: Is there a way where I can modify query in this data connection file and that change is reflected wherever this data connection is refered? I just want to add "order by" clause in the query so that data in drop down is in alphabetical order.

Any help will be much appreciated.

Thanks in advance.