https://bugs.freedesktop.org/show_bug.cgi?id=81336
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Version|4.2.4.2 release |4.2.0.0.alpha0+ Master --- Comment #5 from [email protected] --- Seems to be a special problem as Terrence wrote: You have to wirte SELECT * FROM "Tabelle1" WHERE NOT "Flag" != '' instead of SELECT * FROM "Tabelle1" WHERE "Flag" IS NULL What doesn't work is SELECT * FROM "Tabelle1" WHERE "Flag" = '' A cell in calc couldn't have the same properties as a field in a database. There is a difference between an empty field an NULL in a database. But base couldn't solve this problem yet. The cell isn't recognized as empty text or as 0 ... When I start 4.2.0.0beta2 the query couldn't be opened. Te message appears: SQL Status: HY000 Error code: 1000 syntax is ambiguous Same in LO 4.2.0.0alpha0+ The query works in LO 4.1.6.2. So I set the version to the first 4.3. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
