UDCX stored proc not working - sometimes - InfoPath Dev
in

InfoPath Dev

UDCX stored proc not working - sometimes

Last post 07-15-2016 02:36 PM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-13-2016 10:45 AM

    UDCX stored proc not working - sometimes

     Been a while since I've posted here...but the issue I am having is using a SQL stored proc (as a secondary data source) that I created a UDCX file from and uploaded to SP ....on a new form it works as expected...but if I have retrieved a record via a query, the UDCX secondary data source does not return any rows...the sql statement is correct...just no data...when I deleted the UDCX data source and re-created it to be an internal data source it works as expected in all scenarios...so for kicks I added the udcx data source back in and again - no rows after I queried a record....took it back out and re-created the data source internally again and all is fine.

    ???? 

    Filed under:
  • 07-15-2016 02:36 PM In reply to

    Re: UDCX stored proc not working - sometimes

    Can you use SQL Profiler to see if the query is running at all?
    Hilary Stoupa

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