To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=77865
------- Additional comments from [EMAIL PROTECTED] Fri Jul 6 09:08:54 +0000
2007 -------
I have a similar behaviour with Oo2.0.4 (Debian package *.2.0.4.dfsg.2-7etch1)
running on linux 2.6.18-3-486. Sample code below generates the problem that a
ResultSet is not created to be updateable when the Statement
ResultSetConcurrency is set to UPDATABLE. SCROLL_INSENSITIVE seems to work ok,
however. I have checked that the ResultSet is read correctly but cannot be
updated, but this is not shown below. The data source file has write permission
for all users.
REM ***** BASIC *****
Sub Main
Dim DatabaseContext As Object
Dim Names
Dim DataSource As Object
Dim Connection As Object
Dim Stmt As Object
Dim Rs As Object
DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
Names = DatabaseContext.getElementNames()
DataSource = DatabaseContext.getByName(Names(2))
MsgBox DataSource.Name 'data source is found ok
MsgBox DataSource.IsPasswordRequired 'Result=false
Connection = DataSource.getConnection("","")
Stmt=Connection.createStatement()
MsgBox Stmt.ResultSetConcurrency 'Result=1007
MsgBox Stmt.ResultSetType 'Result=1003
Stmt.ResultSetConcurrency=com.sun.star.sdbc.ResultSetConcurrency.UPDATABLE
Stmt.ResultSetType=com.sun.star.sdbc.ResultSetType.SCROLL_INSENSITIVE
MsgBox Stmt.ResultSetConcurrency 'Result=1008
MsgBox Stmt.ResultSetType 'Result=1004
Rs=Stmt.executeQuery("SELECT ""Description"" FROM ""Purchases""") 'Data
are read
ok into Rs
MsgBox Rs.ResultSetConcurrency 'Result=1007 (Should be 1008)
MsgBox Rs.ResultSetType 'Result=1004
MsgBox Stmt.ResultSetConcurrency 'Result=1007 (Should be 1008)
MsgBox Stmt.ResultSetType 'Result=1004
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]
