To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=65554
Issue #:|65554
Summary:|rowset update crash for big table
Component:|Database access
Version:|OOo 2.0.2
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:|rekel
------- Additional comments from [EMAIL PROTECTED] Thu May 18 11:54:30 -0700
2006 -------
I'm not quite sure if this issue fits more in "database" or in "API".
I have a database made in the embedded HSQL of Base, enclosing "TAG NO" table
which has something like 7500 records.
In this table, I have a field "SELECTED", defined as Tiny Integer. I wanted to
set the value 0 to each record for this field. As i just moved in and wanted to
try a bit the functionalities of basic, I entered the following code:
oBaseContext = CreateUnoService("com.sun.star.sdb.DatabaseContext")
oDataSource = oBaseContext.getByName("TEST 3")
oCon = oDataSource.getConnection("","")
dest = createUnoService("com.sun.star.sdb.RowSet")
With dest
.activeConnection = oCon
.CommandType = com.sun.star.sdb.CommandType.COMMAND
.Command = "SELECT * FROM " & Chr(34) & "TAG NO" & Chr(34)
.execute
.afterLast
End With
rown=dest.RowCount
dest.first
Do until dest.islast()
coln=dest.FindColumn("SELECTED")
dest.updateInt(coln,0)
dest.updateRow
dest.next
Loop
The macro starts and runs for a (long) time, around 5 minutes, and then I have a
crash of openoffice... or not! So, sometimes, it works, sometimes it doesn't...
This looks random. Maybe it's due to the memory usage, I don't know. By the way,
doing a similar code in MS Access takes much less time.
---------------------------------------------------------------------
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]
