Issue 19722 - Cannot generate a query with uncommon fieldnames
Summary: Cannot generate a query with uncommon fieldnames
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC4
Hardware: PC All
: P4 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-17 20:26 UTC by andreschnabel
Modified: 2006-05-31 14:29 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description andreschnabel 2003-09-17 20:26:39 UTC 
Following Problem:

The geman localized Mozilla Adressbook consists of colums with uncommon
Fieldnames like "Telefon (geschäftl.)" or "benutzerdef. 1".

If I try to generate a query, I can select these colums for the query, but the
SQL Statement will become incorrect.

If a correct (and valid) SQL-Statement was:
SELECT "Vorname", "Nachname", "Telefon (gesch.)" FROM "Collected Addresses"
OOo will change this to:
SELECT "Vorname", "Nachname", ")" FROM "Collected Addresses" "Collected Addresses"
as soon as you switch to design view and back again to SQL.
Comment 1 marc.neumann 2003-09-18 10:18:28 UTC 
I can reproduce this.

The problem is the '.' in the field name, which is not SQl 92 stardard. 

Bye Marc
Comment 2 ocke.janssen 2004-01-30 14:44:08 UTC 
fixed in cws oj08
Comment 3 hans_werner67 2004-02-02 12:25:41 UTC 
change subcomponent to 'none'
Comment 4 ocke.janssen 2004-02-02 13:46:07 UTC 
fixed.
Comment 5 marc.neumann 2004-02-25 13:00:56 UTC 
set to fixed
Comment 6 marc.neumann 2004-02-25 13:01:16 UTC 
verify in CWS oj08
Comment 7 marc.neumann 2004-04-27 09:59:43 UTC 
Hi,

fixed in current developer build -> close.
The current developer build can be found at
http://download.openoffice.org/680/index.html
Feel free to reopen if this issue is not fixed in the developer build.

Bye Marc