Re: SQL mess?

>
> You may want to cancel mine...
>
> Regards
> Olivier
>
> Ocke Janssen escreveu:
>> 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@...
>>>
>>
>>
>
> ------------------------------------------------------------------------
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>