I've created a Microsoft Word 2000 document with a headline which I don't
want to appear in page one, so I made a section break for having a different
headline on page 1. The .doc document preview seems right.
The problem is when I import that .doc document into OpenOffice Writer
version 2.1, where the headline is shown on all its pages (including in page
one). Is this a detected bug ?
Gabriel.
-----Mensaje original-----
De: Matthias B. [mailto:[EMAIL PROTECTED]
Enviado el: martes, 20 de marzo de 2007 13:39
Para: dev
Asunto: [dev] Case-insensitive pattern search in Calc databases doesn't
work.
I've created a database that references a Calc document. I get an
"Invalid Statement" error trying to use the following SQL statement
SELECT "Tabelle1"."A" AS "A", "Tabelle1"."B" AS "B", "Tabelle1"."C" AS
"C" FROM "Tabelle1" AS "Tabelle1" WHERE ( LOWER ( "Tabelle1"."A" )
LIKE 'g%' )
The same statement works fine on a HSQL database. If I either remove
the "LOWER" or replace "LIKE" with "=" the statement works on the Calc
database. So apparently it is the combination of LIKE and LOWER that
the Calc database can't process.
Does someone know a workaround for doing case-insensitive pattern
searches in a Calc database?
Matthias
p.s.: As this seems to be a bug I've opened issue 75557
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
