Issue 20615 - Database descriptions not shown between Access 2003 RC and OOO 1.1 RC5
Summary: Database descriptions not shown between Access 2003 RC and OOO 1.1 RC5
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC5
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: OOo 3.3
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-10-02 17:23 UTC by jhansonxi
Modified: 2017-05-20 10:23 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
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 jhansonxi 2003-10-02 17:23:15 UTC 
Access database descriptions for table columns are not shown in OOO Table Editor
for ODBC connected database and vice-versa.

Steps to reproduce:
1.  Create a table in OOO and set a description for a column.
2.  Open the database in Access 2003 and show the table in Design View.
3.  Result - descriptions not present.
4.  Set description for a column in Access 2003.
5.  Edit table in OOO and check the column description.
6.  The column description set in Access is not shown.
Comment 1 Frank Schönheit 2003-10-06 07:29:46 UTC 
correcting sub component (see
http://www.openoffice.org/issues/describecomponents.cgi?component=Database%20access,
please), and default owner
Comment 2 marc.neumann 2003-10-06 09:13:53 UTC 
Hi Ocke,

Is it possible to get these information via ADO?

Bye Marc
Comment 3 ocke.janssen 2003-10-06 09:58:25 UTC 
Hi,

the decription which is set for the column will be saved inside
OpenOffice and not the database fileformat (Access). It is no
description for the column, more a help text which will be displayed
when the mouse point goes over the column in the grid control. May be
Ado supports the description of columns with their provider specific
properties of columns. We have to investigate this.

Best regards,

Ocke
Comment 4 ocke.janssen 2003-10-08 11:35:43 UTC 
Set target.
Comment 5 hans_werner67 2004-02-02 12:12:37 UTC 
change subcomponent to 'none'
Comment 6 ocke.janssen 2010-01-13 07:52:29 UTC 
Fixed in cws dba33f.
Comment 7 ocke.janssen 2010-05-12 07:32:22 UTC 
The table designer now contains an extra column named "column description".
This column contains the description which are returned by the database itself. 

The update of this column value depends on the capabilities of the driver and
can not be investigated before trying to store :-) 
My first try to store it with Access wasn't successful.

Please verify. Thanks.
Comment 8 marc.neumann 2010-05-31 08:21:43 UTC 
verified in CWS dba33f

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33f