HI,
This issue is about whether a result set returned by ExecuteQuery on a
statement can be updated.
This code for instance: ( shortened from the Issue entry )
Sub Main
Dim DatabaseContext As Object
Dim DataSource As Object
Dim Connection As Object
Dim RS as object
DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
Names = DatabaseContext.getElementNames()
DataSource = DatabaseContext.getByName("Computers")
Connection = DataSource.getConnection("","")
Stmt=Connection.createStatement()
Stmt.EscapeProcessing = TRUE
Stmt.ResultSetConcurrency=com.sun.star.sdbc.ResultSetConcurrency.UPDATABLE
Stmt.ResultSetType=com.sun.star.sdbc.ResultSetType.SCROLL_INSENSITIVE
RS = Stmt.executeQuery("SELECT * FROM ""Computers""") 'Data are read
ok into Rs
RS.Next
rs.movetoinsertrow
End Sub
will generate an error on the last line because the result set is read only.
While this code
Sub Main
Dim DatabaseContext As Object
Dim DataSource As Object
Dim Connection As Object
Dim oRowSet as object
DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
Names = DatabaseContext.getElementNames()
DataSource = DatabaseContext.getByName("Computers")
Connection = DataSource.getConnection("","")
oRowSet = createUnoService("com.sun.star.sdb.RowSet")
With oRowSet
.activeConnection = Connection
.CommandType = com.sun.star.sdb.CommandType.COMMAND
.Command = "SELECT * FROM ""Computers"""
.execute
.Next
.movetoinsertrow
End With
Connection.dispose
End Sub
Gives no error ( and is just how I have always done it )
But the question is - should the first version be in read only mode or
not - is this a confirmed issue or an invalid one...
ps - tested this just now with OO.o 3.0 Dev m_13 under XP
Thanks
Drew
--
OpenOffice.org User Community Forum: http://user.services.openoffice.org
United States PostgreSQL Association: http://www.postgresql.us/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
