Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

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

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.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.