Le 19/02/2015 15:00, Ian Whitfield a écrit :
Hi Ian, > But when I go back into my Database with the Base Front End the RecordID > is still marked as 'No Auto-Increment' and still will not change!! > > What am I doing wrong and how do I urgently fix this?? Did you read Fernand's comment ? You need to look very carefully through your form's properties and controls to check where and if the form controls might have referenced the old field as this is stored in the ODB xml. I would add the following questions : - your old RecordID was just an INT that you filled in yourself - so now that you have converted it to INT AUTO_INCREMENT, did you regenerate the values, or have you just carried on from the previous lastinsert_id() of the RecordID field ? If the new values of your newly redefined field do not match the values you had originally, there will naturally be problems with form data representation... Ways around this : - reindex your table using the appropriate mysql command ; - run mysqlcheck from the command line I don't use phpMyAdmin a great deal, so I don't know whether you have access to these commands from that UI - if not, you will have to get your hands dirty and use the console/terminal, which is what most db admins do anyway. If your data _is_ coherent, then the problem lies with your form and/or LO. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
