I had the form saving the required fields to a DB table, but then I added some more fields to the form that I also want to save.
I deleted the DB table and recreated it after adding the fields, I deleted the Save DB event and re-created it, but the form refuses to save the new field data. I've done this a couple times, but the fields that get saved do not update.
I've attached the debug output as a file, the correct fields are displayed in the array but the "insert into " command does not have all the fields ([delivery_options] and [recording_type] are missing, even though they have data).
The DB structure is correct (it was created by chronoforms) - the fields names match the column names.
Sensitive data has been removed from the debug output.
Any help gratefully appreciated!
Peter
I deleted the DB table and recreated it after adding the fields, I deleted the Save DB event and re-created it, but the form refuses to save the new field data. I've done this a couple times, but the fields that get saved do not update.
I've attached the debug output as a file, the correct fields are displayed in the array but the "insert into " command does not have all the fields ([delivery_options] and [recording_type] are missing, even though they have data).
The DB structure is correct (it was created by chronoforms) - the fields names match the column names.
Sensitive data has been removed from the debug output.
Any help gratefully appreciated!
Peter
Hi Peter,
You can add new columns to an existing table but you then need to click the Delete Cache icon in the Forms Manager to update CF's records as it keeps these for 24 hours. Please see this FAQ
Bob
You can add new columns to an existing table but you then need to click the Delete Cache icon in the Forms Manager to update CF's records as it keeps these for 24 hours. Please see this FAQ
Bob
This topic is locked and no more replies can be posted.
