Apache OpenOffice Community Forum

i created a database and a table but could not add data. created a form for the table but still could not add data. database, table and form all show in respective windows. what am I missing?

Does your table have a Primary Key that Auto Increments?

i dont have a primary key. will try to figure out how to add one or redo it since it is a small table and no data will be lost for sure

Spreadsheets use Row numbers to differentiate data rows.
Databases require a unique Primary Key in order to differentiate the data rows.
Go to Tools->SQL and edit and enter the following SQL command it will add a proper Primary Key to your table.

got status msg

1: Primary key not allowed in statement [ALTER TABLE "track" ALTER COLUMN "ID" INTEGER GENERATED BY DEFAULT AS IDENTITY]

thank you, had to redo the id field.

i was successful in adding a key but thought problem solved before i tried to enter data. forms created for table dont let me add row

The Primary Key must be on your form. If you don't want to see the Primany Key while entering data on your form you can hide it.

thanks much