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

Hi Alex

I really appreciate your help here!!

But still no luck - My replies are below.....

A quick, alternative possibility :

Create a new ODB file that connects to your database. Save it under a
new name.

Open the newly named (and currently empty, at least with regard to
forms, queries, etc) ODB file.
I tried this and the ID field comes through as 'No increment' and still will NOT change!!

Did you read Fernand's comment ?
Yes - There is only ONE field on my Form that calls this field. The one I'm trying to change.
your old RecordID was just an INT that you filled in yourself -
No - it was empty, like all my fields), and I imported my old data from a CSV file and then started to work. That,s when I discovered I had not set it to Auto Increment.
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 ?
I can not change it so have not regenerate it.
All I can do at the moment is enter the next number by hand.

Ways around this :
- reindex your table using the appropriate mysql command ;
- run mysqlcheck from the command line
I'm NOT a DB Admin at all I just need this DB to keep all the details of my Group. The DB is just a 
very important tool to me!!
I tried to run the 'mysqlcheck' command and I don't know what the output is but this is what I got 

 Variables (--variable-name=value)
and boolean options {FALSE|TRUE}  Value (after reading options)
--------------------------------- -----------------------------
all-databases                     FALSE
all-in-1                          FALSE
auto-repair                       FALSE
character-sets-dir                (No default value)
compress                          FALSE
databases                         FALSE
debug-check                       FALSE
debug-info                        FALSE
default-character-set             (No default value)
fast                              FALSE
fix-db-names                      FALSE
fix-table-names                   FALSE
force                             FALSE
extended                          FALSE
host                              (No default value)
write-binlog                      TRUE
port                              0
quick                             FALSE
silent                            FALSE
socket                            (No default value)
ssl                               FALSE
ssl-ca                            (No default value)
ssl-capath                        (No default value)
ssl-cert                          (No default value)
ssl-cipher                        (No default value)
ssl-key                           (No default value)
ssl-verify-server-cert            FALSE
use-frm                           FALSE
user                              (No default value)

Thanks again

Pretoria RSA

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.