General

Re: Problem submitting empty field to database

klilley — Wed, 23 May 2007 21:06:36 GMT

Matt Faus:
Hi Kris,

You need to make sure that the xsi:nil='true' attribute is not present on the node that you are trying to submit as a blank string.

Where exactly do I need to check that? I've looked through the files in the .xsn file and can't find that attribute anywhere.

Thanks,

Kris

Re: Problem submitting empty field to database

Matt Faus — Sun, 06 May 2007 03:21:56 GMT

Hi Kris,

You need to make sure that the xsi:nil='true' attribute is not present on the node that you are trying to submit as a blank string.

Re: Problem submitting empty field to database

B.Shiva Prasad — Thu, 03 May 2007 06:42:06 GMT

Hi klilley,

If you are going this solution through code set the field that you want to set blank as "string.Empty". Other wise make a rule for that field you want empty. In rule select the field's value and in the field's text box select the field that you want empty and leave the value text box as it is and press ok.

Hope this will help you.

Problem submitting empty field to database

klilley — Wed, 02 May 2007 19:33:23 GMT

I have two forms with all fields in a repeating section. They are going to be filled out on a disconnected tablet PC, and submitted to an Access database upon return to the office. I have been able to merge all of the xml files for the first form together and submit them to the database. That worked fine. The problem I'm having is with the second form. There are three fields that make up the key for that table, and one of those fields is allowed to be an empty string. The problem is that when I try to submit a form with that field empty, it is being interpreted as a NULL value instead of an empty string. In the xml file, the field shows like this:

BldgCode=""

To me, that is an empty string, but apparently it doesn't get interpreted that way when it is submitted to the database. How can I get it to submit as an empty string?

- Kris