I have a table setup with an auto-increment field (the PK). I am not using the "auto generated" forms (eg. calling the DbSQL::HTML:: template routines)... I'm creating my own form elements within the templates.
Question: How do I use this auto incremented field? Do I just leave it blank and let the database fill it in or do I need to query the database for the new ID number and insert it into my form that the user fills out?
When I just leave the field blank, I get this error "Cannot insert duplicate key in object 'Claims'". I can delete the exising record but then soon after I just get the same error. As if it is not incrementing the ID field. There seems to be very little documentation on this specific feature.
Question: How do I use this auto incremented field? Do I just leave it blank and let the database fill it in or do I need to query the database for the new ID number and insert it into my form that the user fills out?
When I just leave the field blank, I get this error "Cannot insert duplicate key in object 'Claims'". I can delete the exising record but then soon after I just get the same error. As if it is not incrementing the ID field. There seems to be very little documentation on this specific feature.
Retrieving the Auto-increment number?