On 02/18/2015 05:35 PM, Alexander Thurgood wrote:
Le 18/02/2015 15:23, Ian Whitfield a écrit :
Yesterday I found I had not set my Keyfield (RecordID) to Auto Increment
so I set a new field with phpMyAdmin called 'id'. And this is now
working fine and Auto incrementing. I deleted the old RecordID field.
Why did you do that ?
Why not just alter the existing Keyfield (RecordID) to autoincrement ?
I tried several times and the Auto Increment just reverted to 'NO' every
time I saved it.
When you talk about the Keyfield, do you mean that this was a PRIMARY
KEY or was it a reference for other tables (FOREIGN KEY)?
Yes I mean the Primary Key - I have no Foreign Keys
Did you attribute PRIMARY KEY status to the new field that you created?
Did you recreate any references (FOREIGN KEYS) to other tables ?
I deleted the old Primary key and marked the new field as Primary
If you didn't, then by deleting your original RecordID field, you
probably deleted the primary key and/or any references as well, and in
all likelihood that is the reason why the forms that relied on that key
to be set no longer work.
In which case should I rather export my data out and start again?? My
feeling is this might be the best and quickest way to go.
Thanks for the help.
--
To unsubscribe e-mail to: [email protected]
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
