https://bugs.documentfoundation.org/show_bug.cgi?id=165458
--- Comment #3 from [email protected] --- The only thing I could do is send you the complete database. Everthing else is clearly written here. SELECT "Artist"."Name" || ' - ' || "Herkunft"."Kuerzel" || ' - ' || "Artist"."Laendercounter", "Artist"."ID", "Artist"."Name", "Herkunft"."Kuerzel", "Artist"."Laendercounter", "Artist"."Gruppenkennzeichen", "Artist"."Ordner" FROM "Artist", "Herkunft" WHERE "Artist"."Herkunft" = "Herkunft"."ID" ORDER BY UPPER ( "Artist"."Name" ) COLLATE "UNICODE" ASC, "Herkunft"."Kuerzel" ASC saved as "artist_for_selection" in the previous version 24.7.2 shows "SQL syntax error" when opened for editing or called for running. A form using "artist_for_selection" runs just fin with the correct sorting. SELECT "Artist"."Name" || ' - ' || "Herkunft"."Kuerzel" || ' - ' || "Artist"."Laendercounter", "Artist"."ID", "Artist"."Name", "Herkunft"."Kuerzel", "Artist"."Laendercounter", "Artist"."Gruppenkennzeichen", "Artist"."Ordner" FROM "Artist", "Herkunft" WHERE "Artist"."Herkunft" = "Herkunft"."ID" ORDER BY UPPER ( "Artist"."Name" ) ASC, "Herkunft"."Kuerzel" ASC also works fine and does not throw an sql error but of course has crappy sorting. No idea, what else you need. -- You are receiving this mail because: You are the assignee for the bug.
