InfoPath Dev

When I submit the form, the following things happen as expected:

1. It appears in the document tab in DAT.
2. It appears in the SharePoint forms library

The following things happening are un-expected

1. It creates a record in the SQL server where only the doc id is getting correctly updated to the mapped field (which is also the primary key) in the SQL server.
2. Rest of the fields get NULL value.

Any idea what might be causing this problem?

Can you include a screenshot of the database mapping tab in DAT, and also check eventvwr for any errors?

Thanks.

Attached is the screeshot.  I checked the event viewer.  There are no new errors.  All existing ones are old errors when I had the configuration incorrect.

The node path is relative to the parent node path, so you will need to remove the my:myFields/ from the column node paths

Hi binoj,

The field paths must be relative to the table path. So if the table is mapped to my:fields, then all columns below must be mapped relative to that. You'll need to correct the database mapping to reflect this. I am attaching a screenshot to clarify this.

Can you try this and let us know?

Thanks!

That worked very well.

Thanks a lot guys.

 Binoj.