<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - FIREBIRD: Impossible to create an autovalue key when inserting a new table"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=130345#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - FIREBIRD: Impossible to create an autovalue key when inserting a new table"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=130345">bug 130345</a>
from <span class="vcard"><a class="email" href="mailto:robert@familiegrosskopf.de" title="Robert Großkopf <robert@familiegrosskopf.de>"> <span class="fn">Robert Großkopf</span></a>
</span></b>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>