Issue 20601

Summary: ColumnsCollection is empty with native query
Product: Base Reporter: marc.neumann
Component: codeAssignee: marc.neumann
Status: CLOSED FIXED QA Contact: issues@dba <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1 RC5   
Target Milestone: OOo 2.0   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 20198    

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