[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130345

--- Comment #5 from Robert Großkopf <robert at familiegrosskopf.de> ---
Autoincrement isn't supported by Firebird at all.
There is a special generator created for.

But when we want to change from HSQLDB to Firebird the working internal
database should offer this in another way. When changing from internal HSQLDB
to Firebird with the migrationwizard the autovalue will be created for existing
tables. So it is implemented somewhere in this code. 

We could
- change the wizard to choose the possibility to set AutoIncrement while
importing rows, which has already a value in the field. The Generator has to be
set afterwords with the max value of the field.
- change the table editor. It should be possible to read the max value of a
Integer field and set this value to the generator.

Since LO 4.2 we have an experimental Firebird database. It is 6 years ago.
Seems it is too tricky to get it working for us. I won't use this kind of
internal database.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200214/14a3c352/attachment.htm>