1) Your index.count file is corrupt. Edit the number in that file to the LAST record number in your default.db file, and make sure that you have enabled tracking via the $db_track variable in the default.cfg file.
2) The problem is that if you have the DATE field editable by your users, it will pose problems with editing it since users don't know the format...Two solutions:
a) Use a HIDDEN field in your sub html_record_form, like the following:
<input type="hidden" name="Date" value="$rec{'Date'}">
b) Add an example of how the format should look, like the following:
Please enter the following date format: (dd-mmm-yyyy)
Also, if you have edited the DATE subroutines in the default.cfg file, then that may pose problems with modifying existing records with different date formats.
Regards,
Eliot Lee
2) The problem is that if you have the DATE field editable by your users, it will pose problems with editing it since users don't know the format...Two solutions:
a) Use a HIDDEN field in your sub html_record_form, like the following:
Code:
<input type="hidden" name="Date" value="$rec{'Date'}">
b) Add an example of how the format should look, like the following:
Code:
Please enter the following date format: (dd-mmm-yyyy)
Also, if you have edited the DATE subroutines in the default.cfg file, then that may pose problems with modifying existing records with different date formats.
Regards,
Eliot Lee