Qdabra Database Accelerator

Re: DBXL submit to SQL server is creating NULL records

binoj — Fri, 23 Apr 2010 18:31:01 GMT

That worked very well.

Thanks a lot guys.

Binoj.

Re: DBXL submit to SQL server is creating NULL records

ErnestoM — Fri, 23 Apr 2010 18:21:36 GMT

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!

Re: DBXL submit to SQL server is creating NULL records

Jim Cantwell — Fri, 23 Apr 2010 18:17:04 GMT

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

Re: DBXL submit to SQL server is creating NULL records

binoj — Fri, 23 Apr 2010 18:10:51 GMT

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.

Re: DBXL submit to SQL server is creating NULL records

ErnestoM — Fri, 23 Apr 2010 17:22:58 GMT

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

Thanks.

DBXL submit to SQL server is creating NULL records

binoj — Fri, 23 Apr 2010 17:01:44 GMT

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

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

The following things happening are un-expected

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.
Rest of the fields get NULL value.

Any idea what might be causing this problem?