Re: [libreoffice-users] Re: LO Base Problem

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: users+unsubscribe@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