Mar 7th, 2010, 10:30 AM
Hey Dave,
VERY interesting...! I've encountered this myself a couple of times when I was manually editing the database table fields, but never just from updating the fields from within Form Tools.
By the sounds of it, what happened was that when you updated the database column fields on the Edit Form -> Database tab, the query to update the database table column names ran properly but the DB column field update query DIDN'T. So you then had a discrepancy which FT couldn't reconcile.
I looked at the code and it doesn't have any sort of rollback code in place to ensure the DB table col names and database records are always in synch.
This is bad. I'll log this as a bug and fix it in an upcoming build.
Thanks Dave.
- Ben
VERY interesting...! I've encountered this myself a couple of times when I was manually editing the database table fields, but never just from updating the fields from within Form Tools.
By the sounds of it, what happened was that when you updated the database column fields on the Edit Form -> Database tab, the query to update the database table column names ran properly but the DB column field update query DIDN'T. So you then had a discrepancy which FT couldn't reconcile.
I looked at the code and it doesn't have any sort of rollback code in place to ensure the DB table col names and database records are always in synch.
This is bad. I'll log this as a bug and fix it in an upcoming build.
Thanks Dave.
- Ben