Table field ID index and autovalue=yes not working

[vgarroc]

Hi all

I’m quite frustrated with my first table. I created a new database; I proceeded to create a new table with two fields, one test the other image. As I proceeded to close the table I am asked to create an index, the ID which is set to unique and Autovalue. Then all is saved.
Well, it does not work. When I enter the data, the ID field shows nothing; if I save it gives this error:
Error inserting the new record at ./connectivity/source/commontools/dbtools.cxx:746
SQL Status: 23000
Error code: -10

Attempt to insert null into a non-nullable column: column: GroupImage table: MGB_Parts_Group in statement [INSERT INTO “MGB_Parts_Group” ( “Group”,“ID”) VALUES ( ?,?)] at ./connectivity/source/drivers/jdbc/Object.cxx:173

What is wrong? Many thanks.

[RobertG]

You opened the dialog for creating an index. Isn’t needed here. Have a look at the bottom of your screenshot: AutoVale → No should be AutoValue → Yes. You haven’t written which database you use. With internal HSQLDB you could change the filed this way. With internal Firebird this could only be created as AutoValue → Yes when creating the table.

[vgarroc]

Thank you Robert… maybe It was late and I was dizzy after many previous consultations with documentation, tips, videos, tutorials… But something is not working.
I stated from scratch with a new DB. Index GroupID: AutoVale = Yes and Unique. I think the problem was when I thought I could rename the field ID or add a new indexed field and delete ID.
Anyway, I am back on course. Cheers