Forums

I know you have answered this question before but I can't find the original post. I created a form that has been working fine, I added a field to the table and the form. I can not get the form to update the new field. I have tried to turn off and on the "Enable Data Storage" option and saved the report. I checked the name of the field and it matches exactly. I can't seem to get the debug report to show up so that is no added info. Thanks in advance.

Hi fredm,

By all means email or PM me the site URL and a SuperAdmin login and I'll take a quick look.

Bob

Hi fredm,

The DB Connection was turned off but with it on everything looks good. The BMIC data is being saved OK.

Bob

Then I have a real problem that I do not understand. By saying the DB Connection was turned of I am assuming you mean the check box that says "Enable Data storage". The problem on my end seems to be that the BMIC field won't update while the others are, I added another field to test and it would not update either all of the others seem fine. I am testing through the app I am trying to build, could that in someway make a difference? It seems to me that it must have something to do with the CF learns about new fields, I just have enough experience to figure it out yet.

Hi fredm,

You need to refresh the DB Connection after any changes to database column names. In the Form Editor click the DB Connection tab and set the Connection to 'No'. Click the 'Apply icon in the toolbar to save the form, open the DB Connection tab, set the Connection back to 'Yes' and re-save the form. This will refresh the copy of the table information that ChronoForms uses.

I'm not clear how you are managing the saves if not through the DB Connections - if you are using the ChronForms code then you will need to make sre that the table classes are updates with the new/changed columns.

Bob

I Fail, I am not doing anything special with the connections, that I know of. I performed the process you described and no change. I have made superficial changes to the from to insure that changes were being saved but even when I added a second new field the neither of the two would update while the others do. How did you test it when it seemed to work?

OK I have solved it sort of, still don't know what I was doin' wrong but made new form copied code and so far it looks like it will work. Thanks for your help. If you are curious log in to <!-- w --><a class="postlink" href="http://www.slidelllittletheatre.org">www.slidelllittletheatre.org</a><!-- w --> with the info I gave you and look under testing->Administration->Database Management->Production List to see what I have learned from you. Thanks for being there. Fred