Repeating table w/SQL data connection can't preserve history

[dsant-bi]

Background: This is a status report form requiring history week to week.

I have the repeating table connected to a SQL data connection. When the
form opens I use this connection to populate this repeating table with the
previous week's milestones (always multiple), is this case 3 rows. Next, I
need to make changes to the 3 milestones and add a fourth. Before the user
submits to DB they are required to pick a week ending date. I use this date
to update the datestamp on the records I'm about to submit. So what I would
expect is 4 new rows in SQL table with the new datestamp, instead I'm getting
1 new row (milestone 4) and 3 updated rows (milestones 1-3) all with the new
datestamp. It seems Infopath can't treat rows 1-3 as new, so it updates the
existing rows. So the big question is how do you maintain a history with
Infopath in a repeating table?

 

[Clay Fox]

You would need to use code to clone the rows.(insert three rows, copy the
last three rows, add another)
I believe there are some forum discussions and code samples on
http://www.infopathdev.com

Also you may want to look at the Database Accelerator package from
http://www.qdabra.com.

Its webservices include history and saudit tracking so you can see who
opened, modified, and closed a document. You can even get to the field level
if needed. It is HIPAA and SOX compliant.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

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