Secondary Data Connection Create Navigator method returns empty

Question

Hi All,

I have an infopath 2007 form where I created a data source which receive data from a MOSS 2007 server list ("Customers"). 

My Issue is when I called DataSources["Customers"].CreateNavigator() method, the innerXML and other major attributes retunrs empty strings. However if I configure the data source to retrieve data automatically, then  the CreateNavigator returns all the data.

(I can't use retrieve data automatically, since I need to populate some data to the DataSource navigator when the form is offline. )

Does somebody know a reason for this strange behavior? 

Thanks and Regards,

Supun Bulathsinghala

 

---

Supun

Answer 1

have you tried to check "Store a copy of the data in the template" just before you configure the data source to retrieve data automatically?

Seems make sense to me that should be checked. Never tried though - a very interesting use case.

one more thing to try is call DataConnection.Execute() - http://msdn.microsoft.com/en-us/library/microsoft.office.infopath.dataconnection.execute(v=office.11).aspx

Answer 2

I'm having almost this exact problem.  But I get empty tags no matter how I configure the secondary data source.  Because of this I get a null reference exception when trying to clone an xml node.  Anyone have any ideas?