To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87383
------- Additional comments from [EMAIL PROTECTED] Wed Apr 2 20:40:51 +0000 2008 ------- Great, in some sense ... That's the expected result, in that it means that your DB's ODBC driver behaves strange. In SQL, identifiers (i.e. names of tables, columns, etc.) can be quoted, that is, surrounded by a so-called quote character. The definition of this quote character is in the responsibility of the database, respectively the driver for this database. What the macro does is checking what your database/driver reports back as quote character (more precise, the API allows for multiple characters, in practice it's only one character) - and obviously that's whitespaces only. Now, since OOo must be able to cope with a wide variety of database backends, it respects the quote character reported by the database/driver. That is, when a statement such as select * from p21.customer is to be sent to the database, then OOo changes the statement to select * from <quote>p21<quote>.<quote>customer<quote> that's because the definition of the quote character is: Whenever a client talks to the DB, it should use this character when quoting identifiers. So, Base is just standard-compliant here. Unfortunately, your database driver reports back a quote character which it cannot interpret afterwards, which I consider a driver bug. Two options: - we change OOo to ignore quote characters when it's mere whitespace. (Actually, I am not *completely* sure if this would be conformant to the standards.) The down side of this is that in fact there *might* be some esoteric databases which also have a whitespace-only quote character, and in fact require it. Those would break. - You convince the vendor of your DB/driver to fix their driver. Well, the third would be - we introduce a per-database option to ignore the quote character, which is OFF by default, and which you need to switch ON for your databases (i.e. for every .odb file) --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- 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]
