InfoPath Dev

On form load I am copying a nodeset from a 2ndary source into the main source.  It all works fine except with a dateTime field that is blank, then I get a validation error "only date and time allowed".  Neither of the data sources fields are set to "Cannot be blank".  When I save the xml and view it, the field is an empty element: <my:DateTo/>. I don't see what is wrong with this.

Any idea what I can do to get this working?

I am actually not even usign this field in the main data source but it seems that in order to do the copy, the schema must match the 2ndary source exactly wlse I get the error "Schema validation found non-data type errors"

Most likely you will need to add code to add an xsi:nil="true" attribute to your my:DateTo nodes if they are blank.

OK, I found some example of yours in the forum and added this code just after copying the datasource to Main:

    XPathNavigator dateNode = xNavMainDataSource.SelectSingleNode("/my:myFields/my:Meetings/my:Meeting/my:DateTo", NamespaceManager);

    dateNode.CreateAttribute("xsi", "nil", NamespaceManager.LookupNamespace("xsi"), "true");

But that only adds the attribute to the first record in my repeating group. How do I add it to all records (Meetings)?

UPDATE:

I also notice in this post that you said the node must be blank before adding the nil attribute. That will defeat my whole purpose of copying the values from a 2nd data source. Is there a way around this?

I'm still struggling with this and would appreciate any help. Thanks.

Could you post the code you're using to copy the data over?

See attached. I'm using some xslt code that I found in one of your forums. The code that adds the nil attribute only adds it to the first Meeting record.

BTW, what does xsi:nil actually do? Is it simply telling Infopath that null values are allowed? Or that the value must be null?

OK, I did some homework. Now I realise xsi:nil means the element MUST be empty. So I've added some xslt and my code works fine now.  Here is the xslt - it adds the "my" namespace and adds xsi:nil to my two date fields if they are blank.

String xsltString = @"<xsl:stylesheet xmlns:xsl='http://www.w3.org/1999/XSL/Transform' version='1.0'>

</xsl:stylesheet>";

Excellent!  Glad to hear you figured it out.