http://qa.openoffice.org/issues/show_bug.cgi?id=102470
I had a fix who wants to be checked in ;-)
- oj
On 03.06.09 01:44, Drew Jensen wrote:
Olivier Hallot wrote:
Hi
I have a Base file that accesses a Calc file serving as table (pure
text)
If I write the query
SELECT "Frente" FROM "Plan1" AS "Plan1" WHERE "Frente" NOT LIKE "XYZ*"
directly from the SQL editor, I can run the query.
However, when I switch to the Query design and back to the SQL
editor, the query is transformed into
SELECT "Frente" FROM "Plan1" AS "Plan1" WHERE NOT "Frente" LIKE "XYZ*"
and the query cannot run as Base complains "it is too complex".
Looks like a bug or did I miss something?
Thanks
Hola Olivier,
Just duplicated that using 3.1 here.
Want to open an issue for that and I will confirm it.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:[email protected]
D-20097 Hamburg http://www.sun.com/staroffice
Sitz der Gesellschaft:
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Haering
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
