Primary key - Auto fill

Discuss the database features
Post Reply
IreneEng
Posts: 19
Joined: Thu Jul 27, 2017 10:00 pm

Primary key - Auto fill

Post by IreneEng »

The primary key field is set to AutoValue but when I enter data in the table, that field is NOT auto-filled. How can correct this?

Thank you in advance.
Apache OpenOffice 4.1.2
Windows 10 ... I think
Top
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: primary key - auto fill

Post by Villeroy »

menu:Tools>SQL...

Code: Select all

ALTER TABLE "x table" ALTER COLUMN "x column" INTEGER IDENTITY
menu:View>Refresh Tables
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Top
Post Reply

Return to “Base”