Issue 6091 - cannot copy a query in writer
Summary: cannot copy a query in writer
Status: CLOSED DUPLICATE of issue 3045
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.0
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dirk.grobler
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-06-24 15:19 UTC by Unknown
Modified: 2006-05-31 14:29 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 Unknown 2002-06-24 15:19:30 UTC 
I have an ODBC connection to a postgres database, using unixODBC 2.2.1
My OS is RedHat 7.2
The database is remote, running postgres 7.0.3

I configured the data source in OpenOffice correctly (v easy, though
documentation somewhat arcane). I can run queries against the data quite
happily. NB the database is quite big, so queries can be slow.

I now go into data sources from Writer ... I can see the query in the explorer.
If I copy the query and then paste into the document, I get Insert Database
Columns dialog, but no columns are made available for selection.

It works OK with tables but not with queries.

The query is:

select count(*) as hits, date_part('month',date) as month,date_part('year',date)
as year from apachelog group by year, month order by year desc, month desc
Comment 1 Unknown 2002-06-24 18:34:22 UTC 
Some more on this.
- I should have said I get the same problem in the official version of
StarOffice 6.0
- against a smaller table, a simple query will appear in the dialog
with fields. However the new table never gets pasted into the document.
- in the above case (ie with the smaller query) I can get the data
into calc however.
- ... as long as I don't try to use datapilot, which throws up
unpredictable results.
Comment 2 Frank Schönheit 2002-07-10 13:42:09 UTC 
to me, this seems the same as issue 3045.

*** This issue has been marked as a duplicate of 3045 ***
Comment 3 michael.bemmer 2003-03-11 17:18:16 UTC 
As mentioned on the qa dev list on March 5th I will close all resolved duplicate
issues. Please see this posting for details. First step in IssueZilla is
unfortunately to set them to verified.
Comment 4 michael.bemmer 2003-03-11 17:56:24 UTC 
As mentioned on the qa dev list on March 5th I will close all resolved duplicate
issues. Please see this posting for details.
Comment 5 hans_werner67 2004-02-02 12:52:50 UTC 
change subcomponent to 'none'