https://bugs.documentfoundation.org/show_bug.cgi?id=130595
--- Comment #5 from Robert Großkopf <[email protected]> ---
Have tested a little bit more:
SELECT * FROM "Table1" WHERE "Name" = :name OR :name IS NULL
must be changed to
SELECT * FROM "Table1" WHERE "Name" = :name OR CAST( :name AS VARCHAR ( 20 ) )
IS NULL
and it will work. You have to set a parameter to the fieldtype of the field
"Name". So if it should work with an INTEGER-field you have to change to
INTEGER here. But: The casting of the parameter isn't needed, because this part
of the query only want to know, if the parameter is without value (NULL).
--
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
