The Form does not contain any new data to submit to the data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mirco Wilhelm - 02 Nov 2007 16:08 GMT

Hi,

it may sound strange but I'm trying to do the following... for the whole day
now.

- database table1 holds various asset information
- database table2 is a structure copy of db table1 and will be used to save
asset information
- the infopath form uses table2 as main and table1 as secondary data source.

I made a form which shows me the asset information and lets me edit some of
the values.

When I try to submit the data to the database I always get some error
message telling me that there's no new data.

> InfoPath cannot submit the form.
> The Form does not contain any new data to submit to the data source

What I've tried so far:
- 1 XML file for reading and saving
- 2 XML files
- 1 Access DB with 2 tables
- 2 Access DBs with 1 table each
- 1 Access DB for saving and 1 XML file for reading

The last combination didn't give an access denied on opening the form, but
still doesn't submit the values.

Did I forget something or is this all totally wrong?

---
mirco

Reply to this Message

Clay Fox - 02 Nov 2007 17:11 GMT

On your tables you need to have a primary key.

Are you starting from a new database type form?

Have you tried a very simple database type form with Table two just to
verify you can query a record and then submit a record?

You have to query table 2 before you can submit table 2.

You may also want to look at the Database Accelerator. http://www.qdabra.com
It makes working with database data much easier and less restrictive.

Signature

Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

> Hi,
>
[quoted text clipped - 29 lines]
> ---
> mirco

Reply to this Message

Mirco Wilhelm - 02 Nov 2007 17:43 GMT

> On your tables you need to have a primary key.

Well, the tables don't have a real primary key, but are linked at two field
(AssetNo and HostName). I tried to make these unique, but for some reason
the source data did have double values in each field.

> Are you starting from a new database type form?

I received a CSV with all the data and made an access file from it (has to
be portable). I made a structural copy of the table for the new values and
linked the two fields.

Only the AssetNo and SerialNumber are mandatory fields in the target table,
both are indexed and unique.

> Have you tried a very simple database type form with Table two just to
> verify you can query a record and then submit a record?

I was working with only 4 fields from the asset list for the testing.

> You have to query table 2 before you can submit table 2.

I thought I was... reading values from AssetList table to the form and
submitting the form content to the NewValues table!?

At least the first part works fine. I can select any AssetNo from a ComboBox
and the form shows all information on this record.

> You may also want to look at the Database Accelerator.
> http://www.qdabra.com
> It makes working with database data much easier and less restrictive.

Reply to this Message