[Libreoffice-bugs] [Bug 42905] Wizard for Table don't apply auto value
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sun Sep 16 07:37:40 UTC 2018
https://bugs.documentfoundation.org/show_bug.cgi?id=42905
Julien Nabet <serval2412 at yahoo.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |lionel at mamane.lu,
| |robert at familiegrosskopf.de
--- Comment #8 from Julien Nabet <serval2412 at yahoo.fr> ---
It seems the auto-increment statement needs to be filled.
For example, if you put AutoValue="Yes" and type "IDENTITY" in auto-increment
statement field, it'll work.
Of course, it works if it's an hsqldb embedded db. With Firebird embedded type,
it won't work, you must type "GENERATED BY DEFAULT AS IDENTITY".
I must recognize it's not very intuitive, I see 2 possibilities to improve the
situation here when putting AutoValue" to "Yes":
1) Fill the auto-increment statement field by default with auto-increment
statement of the related DB.
or
2) Letting the empty auto-increment statement field by default and at the end,
then if autovalue has been selected and auto-increment statement field has been
let empty, retrieve the by default value
Any thoughts?
--
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/20180916/916bd6f0/attachment-0001.html>
More information about the Libreoffice-bugs
mailing list