To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=62646
Issue #:|62646
Summary:|Basic debug hangs on accessing row
Component:|Database access
Version:|OOo 2.0.1
Platform:|PC
URL:|
OS/Version:|Linux
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|dbaneedsconfirm
Reported by:|rnhainsworth
------- Additional comments from [EMAIL PROTECTED] Tue Feb 28 07:38:54 -0800
2006 -------
OO hangs when I try to inpect a variable in the IDE during run time.
The code is as follows and the Subroutine works, taking data from a database,
placing it in a combobox on a dialog and starting the dialog. But ...
Sub SetBankDialog
Dim mDialog as object
'get the dialog from the library
mDialog = DialogLibraries.getByName( "Standard" ).getByName( "DlgViewBanks" )
odialog = CreateUnoDialog(mDialog)
'get the RegN needed for the dropdown list of RegNs
oDBContext = CreateUnoService("com.sun.star.sdb.DatabaseContext")
If oDBContext.HasbyName(DSName) Then
oConnection =
oDBContext.GetByName(DSName).GetConnection("richard","123")
Else
Msgbox("DataSource " & DSName & " is not registered" , 16,"IT")
Exit Sub
End If
sql= "select ""RegN"" from """ & MetaTable & """ where
""Operating""=true"
RowRes = oConnection.createStatement.executeQuery(sql)
'put the data into the fields
olist = odialog.getControl("RegNList")
while RowRes.next
count = olist.getItemCount()
olist.addItem(RowRes.getInt(1),count)
wend
' now put the finished dialog onto the screen
odialog.execute
End Sub
In order to develop the code later, I want to see what is in RowRes. If I put a
break point immediately after RowRes, put a watch on RowRes, everything is fine.
But when I try to 'open' RowRes, the whole of OO relaunches.
It only happens when accessing a database, hence I have allocated this bug here.
Richard
---------------------------------------------------------------------
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]
