Data not saved

[Former Community Member]

Hi all,

When I created the form from a word doc and binding the fields to a SQL Server database, I was able to save all of the data.  However, when I created a dynamic form and then bind the fields to the table in SQL Server, my data is only being saved for the first field in the form.  Really appreciate if you could set some insight into why only the first column being saved and not the rest of the data.  Thanks. Martin

[Former Community Member]

Does LiveCycle Designer have a debug mode capability like in Visual Studio.Net?

[Former Community Member]

I'm even more confused now after I tried to insert data in ALL fields.  Some of the fields retained data and some did not.  (I have a button set up to view previous, next, and add record)

previous: xfa.sourceSet.DataConnection.previous()

next: xfa.sourceSet.DataConnection.next()

add: xfa.sourceSet.DataConnection.addNew()