Re: SQL mess?

> 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: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>