Issue 18592 - The UI shows ADO/MDB columns in alphabetical order.
Summary: The UI shows ADO/MDB columns in alphabetical order.
Status: CLOSED WONT_FIX
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC Windows XP
: P4 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords:
: 74916 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-08-24 22:02 UTC by jeffos2
Modified: 2007-03-02 12:50 UTC (History)
1 user (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 jeffos2 2003-08-24 22:02:46 UTC 
This problem pertains to an ADO datasource accessed via the following URL:
sdbc:ado:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Common 
Files\ODBC\Data Sources\FINANCE.mdb;Mode=Share Deny None;Persist Security 
Info=False

The UI always alphabetizes the column names. To see this use Data Source
Administration to create a new table. Create columns from the top of
C Integer, B Integer, A Integer. Make C the Primary Key and save the table.

Now, edit the table and you will see the columns displayed as A, B, C instead
of the correct C, B, A. 

It does this consistently for all my tables whether in the editor, Query
Designer, whatever.
Comment 1 Frank Schönheit 2003-08-25 07:54:14 UTC 
confirming, targeting, changing priority to P4, changing ownership

fs->oj: When looking at the table (with C,B,A as described by Jeffery)
in MS Access, the columns are in the order C,B,A. Looking at it in OOo
indeed gives A,B,C.
I assume this is about the inconsistencies the jet engine has with
telling us column orders.
Comment 2 ocke.janssen 2003-08-28 09:07:57 UTC 
Hi Jeffery,

I'm sorry to say that the column list, is what I get from ADOX. The
collection give all names in a sorted way. So would only have the
chance to execute a query like "select * from X where 0=1" to get a
possible column order. But is this the correct order or is it the
order which the method to ask the DatabaseMetaData for the columns of
the table? So we got three ways to get a sort order. Which one is the
correct one. I think that the implementors of ADOX have to change the
behavior of the columns collection.

Sorry,

Ocke
Comment 3 marc.neumann 2003-11-04 11:26:11 UTC 
so we can close this issue
Comment 4 hans_werner67 2004-02-02 12:21:06 UTC 
change subcomponent to 'none'
Comment 5 marc.neumann 2007-03-02 12:50:00 UTC 
*** Issue 74916 has been marked as a duplicate of this issue. ***