SQL mess?
|
View:
New views
5 Messages
—
Rating Filter:
Alert me
|
 |
SQL mess?
by Olivier Hallot
::
Rate this Message:
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 -- Olivier Hallot Scinergy Consulting Tel (021) 2224-3224, (021) 8822-8812 Rio de Janeiro, Brasil http://www.scinergy.com.br OpenOffice.org L10N project leader for Brazil --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: SQL mess?
by drewjensen
::
Rate this Message:
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@... |
|
|
Re: SQL mess?
by Ocke Janssen
::
Rate this Message:
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@... > -- Ocke Janssen Tel: +49 40 23646 661, x66661 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:Ocke.Janssen@... D-20097 Hamburg http://www.sun.com/staroffice Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: SQL mess?
by Olivier Hallot
::
Rate this Message:
Jeeezzz!!
we were almost synchronized.... I just did it as well http://www.openoffice.org/issues/show_bug.cgi?id=102471 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@... >> > > Olivier Hallot Scinergy Consulting Tel (021) 2224-3224, (021) 8822-8812 Rio de Janeiro, Brasil http://www.scinergy.com.br OpenOffice.org L10N project leader for Brazil --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: SQL mess?
by Ocke Janssen
::
Rate this Message:
On 03.06.09 13:57, Olivier Hallot wrote: > Jeeezzz!! > > we were almost synchronized.... I just did it as well > > http://www.openoffice.org/issues/show_bug.cgi?id=102471 Wow, that's brain storming ;-) Regards, Ocke > > 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@... > -- Ocke Janssen Tel: +49 40 23646 661, x66661 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:Ocke.Janssen@... D-20097 Hamburg http://www.sun.com/staroffice Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering |
| Free embeddable forum powered by Nabble | Forum Help |
