To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=77865
Issue #|77865
Summary|ResultsetType and ResultSetConcurrency do not change
Component|Database access
Version|OOo 2.2
Platform|All
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|stefanoo
------- Additional comments from [EMAIL PROTECTED] Mon May 28 09:00:13 +0000
2007 -------
I used a calc document to connect a base database (function getVerbindung)
function getVerbindung
dim databasecontext, quelle as object
databasecontext = createUnoService("com.sun.star.sdb.DatabaseContext")
quelle = databasecontext.getByName( “/.../..“)
getVerbindung = quelle.getConnection("","")
end function
When i try to update content of the database via the resultset it did (and will)
not work.
Code Example and Error Message:
sub test
dim verb, set11 as object
verb = getVerbindung
set11 = verb.createStatement
set11.ResultsetType = 1005
' ResultsetType is changing from 1003 to 1004 but never to 1005
set11.ResultSetConcurrency = 1008
'Just 1007 is possible
set11 = set11.executeQuery("Select ""Name"" from ""Personendaten""")
set11.next
msgbox set11.getString(1)
' you can read the first name stored into the database
set11.updateString(1, "Test")
' Error Message: "...Resultset is Read Only", Basic crashs
set11.updateRow
verb.close
End Sub
I tried that with
OpenOffice 2.2 (german version)
Open Office 2.1 (german version)
Open Office 2.1 portable (german version)
everytime on a XP system.
After posting the problem in the OO Forum (german) some people meant it could be
a bug in OO.
One user reported the same problem.
http://de.openoffice.info/viewtopic.php?p=49499#49499
and my own post and responses:
http://de.openoffice.info/viewtopic.php?p=49195#49195
---------------------------------------------------------------------
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]
