Code

Re: Setting non-text values using selectSingleNode

sudlev — Mon, 10 Sep 2012 00:49:48 GMT

...and also the cs project. It would only allow me to attach one file.

Re: Setting non-text values using selectSingleNode

sudlev — Mon, 10 Sep 2012 00:48:06 GMT

No worries Gennady Vanin.

I've attached the form.

Re: Setting non-text values using selectSingleNode

Gennady Vanin (Геннадий Ванин, Новосибирск) — Fri, 07 Sep 2012 14:23:06 GMT

Since you already had trouble with it and ready template with code, could you modify it to create a demo (XSN template+VSTA project) archive (e.g. .zip file) and post it to help others to walk through the discussed issues?

Re: Setting non-text values using selectSingleNode

sudlev — Fri, 07 Sep 2012 01:02:51 GMT

Yes, I can understand. Thankfully someone else went through all the pain so I didn't have to...

You'd think they'd have some kind of guide out there on how to do all this stuff. I mean something as simple as setting a field value programmatically really shouldn't be so painful.

Re: Setting non-text values using selectSingleNode

Hilary Stoupa — Fri, 07 Sep 2012 00:48:38 GMT

Oh, happy to help - that one made me CRY, I swear. I was so glad when I finally found out that I was not actually crazy - that the validation actually works differently in browser vs. filler.

Re: Setting non-text values using selectSingleNode

sudlev — Fri, 07 Sep 2012 00:36:17 GMT

This works beautifully!

I can't thank you enough Hilary, you've been a MASSIVE help!

Danny

Re: Setting non-text values using selectSingleNode

Hilary Stoupa — Thu, 06 Sep 2012 15:06:56 GMT

You aren't a pest.

It turns out this works differently in the browser - I had an email conversation with the InfoPath team at MS about this a couple of years ago, and was told:

             /* ...there are differences in the way MSXML (InfoPath client XML library) and System.Xml (IPFS XML library)
             * are validating the XML against the schema. After executing the SetValue() method, System.Xml
             * recognizes the empty text node as a child of the “my:file” node. As such, a validation error
             * occurs when you attempt to reapply the ‘nil’ attribute.*/

So, I did this instead:

// Because of this, modifying from 'SetValue' to 'DeleteSelf'. MS dev states the following works in client and browser.

            // For details on the below 2 lines, refer to:
            // http://msdn.microsoft.com/en-us/library/system.xml.xpath.xpathnavigator.deleteself.aspx
            fileNode.MoveToFirstChild(); // This moves to the text value of the node.
            fileNode.DeleteSelf(); // This deletes the text value. On delete, node reverts to the parent.
            try
            {
                // Not sure what data type is, so if this fails, it is probably string, so ignore.
                fileNode.CreateAttribute("xsi", "nil", "http://www.w3.org/2001/XMLSchema-instance", "true");
            }

Re: Setting non-text values using selectSingleNode

Gennady Vanin (Геннадий Ванин, Новосибирск) — Thu, 06 Sep 2012 14:06:05 GMT

InfoPath 2010 features unavailable in Web browser forms (comparative compatibility matrix)

Re: Setting non-text values using selectSingleNode

sudlev — Thu, 06 Sep 2012 05:15:43 GMT

Hi again guys,

My code (above) was working beautifully in preview mode in the designer, but now that it's been published it is failing again. Is there a reason this would not work in a browser form?

Sorry to be a pest.

Danny

Re: Setting non-text values using selectSingleNode

sudlev — Wed, 05 Sep 2012 04:19:52 GMT

You were correct, in order to clear the value of the field I needed to add the xsl:nil attribute to the element. As you described in the how to add xsi:nil = "true" thread. I've pasted my code below for reference.
_____________

valueNode.SetValue(string.Empty);

if (!valueNode.MoveToAttribute("nil", "http://www.w3.org/2001/XMLSchema-instance"))

valueNode.CreateAttribute("xsi", "nil", System.Xml.Schema.XmlSchema.InstanceNamespace, "true");//required attribute for non-string values
________________________________

Thanks for your help!

Re: Setting non-text values using selectSingleNode

Jimmy — Tue, 04 Sep 2012 11:26:25 GMT

The problem here is most likely the presence of an xsi:nil attribute. Search this forum for xsi:nil, and you should find plenty of help.

Re: Setting non-text values using selectSingleNode

sudlev — Tue, 04 Sep 2012 05:27:15 GMT

Hi Greg,

Can you assist me with this? I am unable to get my code to work (and I am not a programmer so I've really struggled with this).

What I want to do is set an int field to null or equivalent. I tried using ValueNode.SetValue("") but that gived me invalid data.

I really appreciate any assistance you can offer.

Danny

Re: Setting non-text values using selectSingleNode

pamam — Wed, 20 Apr 2011 15:05:23 GMT

Thanks for the help,

Mel

Re: Setting non-text values using selectSingleNode

Greg Collins — Tue, 19 Apr 2011 22:40:23 GMT

To remove the nil attribute (required before setting a value to a field with the nil attribute), you select the attribute the same way you would select any node, and then delete it. Then you can set the value.

Re: Setting non-text values using selectSingleNode

pamam — Fri, 01 Apr 2011 19:49:23 GMT

How do you remove an attribute programmatically