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
--
Olivier Hallot
Scinergy Consulting
Tel (021) 2224-3224, (021) 8822-8812
Rio de Janeiro, Brasil
http://www.scinergy.com.br
OpenOffice.org L10N project leader for Brazil
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
