Am 25.01.2016 um 10:44 schrieb Marion & Noel Lodge: > Hi Tim, > > It may depend on which Database you are using with LibreOffice. > > I use the H2 Database and in my tables if I make CustomerID's type > BigInt[Identity], > then AutoValue = 'Yes works. That might be worth trying in your situation. > > Noel > -- > Noel Lodge > lodg...@gmail.com >
The Base GUI does not change this attribute for an existing field. Tools>SQL... ALTER TABLE "table name" ALTER COLUMN "CustomerID" INTEGER GENERATED BY DEFAULT AS IDENTITY; [replace "table name" with the actual name of your table in double-quotes] menu:View>RefreshTables... -- To unsubscribe e-mail to: users+unsubscr...@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