https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #1 from Gerhard Schaber <gerhard.scha...@gmx.at> ---
The SDB table was originally created this way:
CREATE TABLE "MitgliederVerband"("ID" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Vorname" VARCHAR(250) CHARACTER
SET UTF8 NOT NULL COLLATE UNICODE_CI_AI,"Nachname" VARCHAR(250) CHARACTER SET
UTF8 NOT NULL COLLATE UNICODE_CI_AI,"Gebdat" DATE,"Strasse" VARCHAR(250)
CHARACTER SET UTF8 COLLATE UNICODE_CI_AI,"Plz" INTEGER,"Ort" VARCHAR(250)
CHARACTER SET UTF8 COLLATE UNICODE_CI_AI,"Telefon" VARCHAR(50) CHARACTER SET
UTF8 COLLATE UNICODE_CI_AI,"Mail" VARCHAR(150) CHARACTER SET UTF8 COLLATE
UNICODE_CI_AI,"Tarifgruppe" INTEGER,"Eintritt" DATE,"Austritt" DATE,"Verein"
INTEGER,"MitgliedsID" VARCHAR(10) CHARACTER SET UTF8 COLLATE
UNICODE_CI_AI,"LandID" INTEGER,"Grad" INTEGER,"Geschlecht" SMALLINT,"Titel"
VARCHAR(50) CHARACTER SET UTF8 COLLATE UNICODE_CI_AI,"Nation"
INTEGER,"Geburtsort" VARCHAR(50) CHARACTER SET UTF8 COLLATE
UNICODE_CI_AI,"Beruf" VARCHAR(50) CHARACTER SET UTF8 COLLATE
UNICODE_CI_AI,"PrfgDatum" DATE,"DANReg" VARCHAR(100) CHARACTER SET UTF8 COLLATE
UNICODE_CI_AI,"PrfgDaten" VARCHAR(250) CHARACTER SET UTF8 COLLATE
UNICODE_CI_AI)
When I create a new DB file, and then run the statement above, the SQL query
works. I do not want to move everything to a new DB. The original is very
complex and it is time consuming to move the DB and macros, etc. At least I
would like to know what is wrong with my current one, so that I do not run into
the same issue again.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
