[Solved] Cannot add Primary Key

[nickblitz]

Hi there,

I am having problems adding a primary key to this people table. I have set the primary key and saved but it just does not stick. . i went back into the table and the pk is still not there.

PLease help.

Thanks.

[Sliderule]

I am having problems adding a primary key to this people table. I have set the primary key and saved but it just does not stick.

But, you have NOT told us what you want the Primary Key to be in the table, therefore, it is difficult to help. Put another way, ¿ ¿ ¿ which field, or, fields will make each record in the table "People" unique ? ? ?

I have ADDED a new field, I named it "PeopleID" and, assigned it a field type of INTEGER, and, constructed it as GENERATED BY DEFAULT AS IDENTITY (START WITH 1) . . . this way . . . you can have more than one person with the same "Name" ( a possibility ) and the database engine ( HSQL ) will assign a unique integer "PeopleID" value when a new record is created, starting with 1 .

WARNING: I just added the new field to your table "People" . . . BUT . . . I did not touch ( even look / open ) any forms or queries ( if any exist ). It is your responsibility to make these changes if needed.

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.

.

[DACM]

I am having problems adding a primary key...I have set the primary key and saved but it just does not stick.

Looks like Sliderule has you all setup.

I'll mention that this is a known bug in the Base GUI. So you may find these links handy or informative for future reference:
http://user.services.openoffice.org/en/ ... 78#p187178
http://user.services.openoffice.org/en/ ... 19#p247019
http://www.oooforum.org/forum/viewtopic ... 884#398884
...

[nickblitz]

thanks!!