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]
