_believe_me_ the addition of 'resync' solved many, many p roblems. The only problem remaining was how to carry the existing defaults through the 'reset' process.
The .def files are used to speed up access and to do things to the database with information that is not stored in the field descriptors of the mysql database itself. They provide a multitude of features in exchange for some problems.
Really, the only major problem of any sort with the .def files is remembering to resync them if you make any changes to the database, and the loss of any user-defaults that were entered -- such as weights and changes to the defaults or pattern match.
Otherwise, they are the reason you can do all sorts of things to the database as simply and cleanly as it is.... such as generation of drop down or check boxes, pre-checking of field lengths and formatting, etc.
http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/
The .def files are used to speed up access and to do things to the database with information that is not stored in the field descriptors of the mysql database itself. They provide a multitude of features in exchange for some problems.
Really, the only major problem of any sort with the .def files is remembering to resync them if you make any changes to the database, and the loss of any user-defaults that were entered -- such as weights and changes to the defaults or pattern match.
Otherwise, they are the reason you can do all sorts of things to the database as simply and cleanly as it is.... such as generation of drop down or check boxes, pre-checking of field lengths and formatting, etc.
http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/