To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=62646
------- Additional comments from [EMAIL PROTECTED] Sat Mar 11 23:09:32 -0800
2006 -------
Agreed - biblio does not crash.
I used both mysql and postgres databases. The mysql database was set up on my
local machine and on a network, the postgres only on the network. Same behaviour
in each case.
The mysql connection was via ODBC.
The driver for the postgres was installed according to the instructions on the
openoffice site.
Both connections work and tables can be accessed via oo database files.
I only reported this as a bug after I changed from using mysql to postgres, as I
thought that had eliminated the driver as the problem source.
For some reason the crash is not generating a crash report. There is an
automatic relaunch of OO2 and recovery of the files open at the time of the
crash. However, the 'next' button to open the crash report tool is not on the
final dialog. I could not quickly see how to activate the crash report tool.
The select statement is not material to the problem. "select * from mytable"
produces a crash, just as the more complex select given below.
The following is a simpler test. When Bibliography (and table biblio) are used,
no crash. When RRatingBase ("Bank") are used, there is a crash. I emphasis: the
code works as part of a more general application. So here, a message box with
'Got Data' appears. But when I try to use the debugger and access 'ResRows'
after it has been obtained, there is a crash.
Sub Main
Dim oDBContext as Object, oConnection as Object, ResRows as Object
REM Const DSName = "Bibliography"
Const DSName = "RRatingBase"
oDBContext = CreateUnoService("com.sun.star.sdb.DatabaseContext")
If oDBContext.HasbyName(DSName) Then
REM oConnection =
oDBContext.GetByName(DSName).GetConnection("dummy","dummy")
oConnection =
oDBContext.GetByName(DSName).GetConnection("richard","123")
Else
Msgbox("DataSource " & DSName & " is not registered")
Exit Sub
End If
REM ResRows = oConnection.createStatement.executeQuery("select * from
biblio")
ResRows = oConnection.createStatement.executeQuery("select * from
""Bank""")
if ResRows.next Then
MsgBox("Got data")
Else
MsgBox("Not got data")
End If
x=0 ' breakpoint set on this stub line
End Sub
---------------------------------------------------------------------
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]
