Issue 20601 - ColumnsCollection is empty with native query
Summary: ColumnsCollection is empty with native query
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC5
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks: 20198
  Show dependency tree
 
Reported: 2003-10-02 12:17 UTC by marc.neumann
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 marc.neumann 2003-10-02 12:17:30 UTC 
- create a new nativ query
- execute the following macro (change datasource and query name)

Sub Main

	sDBName = "your_datasource"
	sQueryName = "your_query"

	oDBContent = createUnoService("com.sun.star.sdb.DatabaseContext")
	oDB = oDBContent.getByName(sDBName)

	handle = createUnoService("com.sun.star.sdb.InteractionHandler")
	oConnection = oDB.connectWithCompletion(handle)	
	
	oQueries = oConnection.getQueries
	oQuery = oQueries.getByName(sQueryName)
	oColumns = oQuery.getColumns

	msgbox oColumns.getCount

End Sub
- the column count is 0.

This bug is the main reason for the issue 20198.
Comment 1 marc.neumann 2003-10-02 12:35:02 UTC 
set target
Comment 2 ocke.janssen 2004-01-29 11:07:11 UTC 
fixed in oj08
Comment 3 hans_werner67 2004-02-02 12:47:12 UTC 
change subcomponent to 'none'
Comment 4 ocke.janssen 2004-02-02 14:08:18 UTC 
.
Comment 5 marc.neumann 2004-03-02 10:16:21 UTC 
set this to FIXED
Comment 6 marc.neumann 2004-03-02 10:16:37 UTC 
verify in CWS oj08
Comment 7 marc.neumann 2004-04-27 10:00:50 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