Re: SQL mess?

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