Infopath Changing data before submiting to SQL
Posted on 2010-08-26
I have a form that submits data to MS sql database.
The form has a repeating table with several fields.
This was working fine until I added a secondary data source to the same sql table.
This was to query some of the data fields.
Now when I submit the data to the main connection the data in my repeating table changers before it is put in the database
So I have two fields in my form that are start time and finish time
If I put 8:00 in my start time and 9:00 in my finish time then submit the data
I get the same data in my database.
But if I add another row to my repeating table with a start time of 10:00 and a finish time of 11:00
The new row has a start time of 8:00 and a finish time of 9:00 the same as the first entry.
The data in the sql database is the same.
But if I clear the form before adding the new data this the data is correct.
The form was working until I added a secondary connection to the database
Any ideas as this is driving me mad