[Libreoffice-bugs] [Bug 116936] Firebird SDBC should implement XRowUpdate interface

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116936

--- Comment #4 from Lionel Elie Mamane <lionel at mamane.lu> ---
To test: create a firebird-embedded database; put some data in it

Create a Basic macros like and run the Tst macro

Sub ensureConnection()
        Dim DBDocUI as Object
        DBDocUI = ThisDatabaseDocument.currentController
        if not DBDocUI.isConnected then
                DBDocUI.connect
        end if
End Sub

Function get_stmt() as Object
        ensureConnection()      
        get_stmt =
ThisDatabaseDocument().currentController.ActiveConnection.createStatement()
End Function

Sub Tst
    dim rs as Object
    dim stmt as Object
    stmt = get_stmt()
    rs = stmt.executeQuery("SELECT * FROM table_name ORDER BY XXXX")
    rs.next()
    rs.updateString(2, "new value")
    rs.updateDate(3, CDateToUnoDate(DateSerial(2020,05,25)))
    rs.updateRow()
    ' this should have set the second column of the first row of table_name to
"new value"
    ' and the third column to the date 25 May 2020
    ' note that first column is column 1

    ' similarly test updateInt, updateTime, updateLong, updateTimestamp,
updateNull, updateDouble, etc
    ' see
https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1sdbc_1_1XRowUpdate.html#a663cf96bf1e722231ffd2587a3ef9103

    Dim col as Object
    col=rs.columns.getByIndex(1) ' fetch the _second_ column. First column is
index 0
    col.updateString("new new value")
    rs.updateRow()
    ' this should have set the second column of the first row of table_name to
"new new value"
    ' and I'm already cheating you a bit, because I'm increasing the scope of
this enhancement :)
    ' this will require to implement the same updateXXXX in Column.cxx
End Sub

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190913/d8a70795/attachment-0001.html>