To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=70227
Issue #|70227
Summary|Second database select against DB2 V9 fails
Component|Database access
Version|OOo 2.0.3
Platform|PC
URL|
OS/Version|Windows 2000
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|buschu
------- Additional comments from [EMAIL PROTECTED] Mon Oct 9 03:03:55 -0700
2006 -------
I tried the following macro, which actually gives only 2 values:
Sub Testsub
Dim DatabaseContext As Object
Dim DataSource As Object
Dim Connection As Object
Dim Statement As Object
Dim ResultSet As Object
Dim i As Integer
DialogLibraries.LoadLibrary("Standard")
DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
DataSource = DatabaseContext.getByName("testdb")
Connection = DataSource.GetConnection("user","pass")
Statement = Connection.createStatement()
ResultSet = Statement.executeQuery("VALUES (1)")
If Not IsNull(ResultSet) Then
IF ResultSet.next Then
MsgBox "Number of values: " + ResultSet.getInt(1)
End If
End If
ResultSet = Statement.executeQuery("VALUES (2)")
End Sub
Result: The first statement works without errors. The message box appears. The
second executeQuery shows error message (translated from German):
"BASIC Run time error. Exception occured. Type:
com.sun.star.lang.DisposedException Message: ."
Database is DB2 V9.1 ExpressC (download for free) on Windows 2000
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
