Re: SQL mess?

> 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