https://bugs.documentfoundation.org/show_bug.cgi?id=105240
Lionel Elie Mamane <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
See Also| |https://bugs.documentfounda
| |tion.org/show_bug.cgi?id=51
| |780
Resolution|--- |NOTABUG
--- Comment #10 from Lionel Elie Mamane <[email protected]> ---
(In reply to Gerhard Schaber from comment #6)
> The following actually works, but causes problems, since in some generic
> code, I need to be aware of all column names:
> INSERT INTO "Lehrgangsliste" ("Tarifgruppe", "Pruefungsgruppe",
> "MitgliedsID", "DatumsID", "Vorname", "Nachname", "Verein", "Grad") VALUES
> (3, NULL, 'YW045', '2016-10-15', 'First name', 'Last name', 701, 12 )
>
> But well, that apparently means I have to change more code.
Well, I'm afraid that explicitly inserting NULL and getting the AutoValue
instead is (I guess) not part of the SQL standard. HSQLDB and MariaDB (and
others) support it as an extension, but e.g. Firebird (you tell me) and
PostgreSQL (I just tested) do not.
For complete portability, you just have to do as you outline above.
You may if you wish file a wishlist bug / enhancement request directly at the
Firebird project; if they decide to implement this extension/feature, we will
get it when we upgrade to whatever version has it.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
