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

InfoPath Dev

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

Last post 08-10-2010 10:38 PM by mahakbhalla. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 07-29-2010 12:06 AM

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

    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.

  • 07-29-2010 12:29 AM In reply to

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

    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.  

     

  • 08-10-2010 10:38 PM In reply to

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

    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.

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.