Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | The UI shows ADO/MDB columns in alphabetical order. | ||
---|---|---|---|
Product: | Base | Reporter: | jeffos2 <jeffos2> |
Component: | code | Assignee: | ocke.janssen |
Status: | CLOSED WONT_FIX | QA Contact: | issues@dba <issues> |
Severity: | Trivial | ||
Priority: | P4 | CC: | issues |
Version: | OOo 1.1 RC3 | ||
Target Milestone: | OOo 2.0 | ||
Hardware: | PC | ||
OS: | Windows XP | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
jeffos2
2003-08-24 22:02:46 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. 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 so we can close this issue change subcomponent to 'none' *** Issue 74916 has been marked as a duplicate of this issue. *** |