Whilst it is recommended that every table should have a primary key
field, as far as I know HSQLDB is the only engine to enforce this by
refusing to allow changes to tables not having one.
I certainly think that the code ought to be fixed so that database
engines that require the field
Yes. As you said, if you click no when it prompts you to create a key now.
Not only can you not create a key later, but you also cannot add data to
the table . Again, I'm using the odb file for my database. Would it not
make sense to block the user from being able to click no for creating a
Here are some examples from simple to more complex. The table's name is
Sample, and its field name is First Name.
1ALTER TABLE Sample ADD COLUMN ID INTEGER PRIMARY KEY;
Strange.. It said it was completed successfully. When I do this, I
can now see the ID column and it appears I can add
Software: Libreoffice base
Version: 3.5.4.2 (Debian Wheezy)
Subject: Cannot add primary key after saving without primary key.
I've got a problem. I'm trying to test some different table designs.
Whenever I create a table without a primary key, I find that I cannot
go back and add a primary key
add primary key after saving without
primary key.
Software: Libreoffice base
Version: 3.5.4.2 (Debian Wheezy)
Subject: Cannot add primary key after saving without primary key.
I've got a problem. I'm trying to test some different table designs.
Whenever I create a table without a primary key
] Cannot add primary key after saving without
primary key.
Software: Libreoffice base
Version: 3.5.4.2 (Debian Wheezy)
Subject: Cannot add primary key after saving without primary key.
I've got a problem. I'm trying to test some different table designs.
Whenever I create a table without
I used the Libreoffice wizard to create the database. It's a local
file. It's an offline laptop and I don't have MySQL or PostgresSQL
running so maybe it's SQLite? What's the process to check the
backend?
Ok,
Database File is an .odb. Open Document Database.
Thanks for your time.
--
For
: David Smith sidic...@gmail.com
To: Tom Davies tomdavie...@yahoo.co.uk
Cc: users@global.libreoffice.org users@global.libreoffice.org
Sent: Sunday, 21 October 2012, 12:16
Subject: Re: [libreoffice-users] Cannot add primary key after saving without
primary key.
I used the Libreoffice wizard
David Smith wrote:
Software: Libreoffice base
Version: 3.5.4.2 (Debian Wheezy)
Subject: Cannot add primary key after saving without primary key.
I've got a problem. I'm trying to test some different table designs.
Whenever I create a table without a primary key, I find that I cannot
go back