[Libreoffice-bugs] [Bug 118094] Firebird: Support more XResultSet functions

[bugzilla-daemon at bugs.documentfoundation.org]

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

Drew Jensen <drewjensen.inbox at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |drewjensen.inbox at gmail.com

--- Comment #2 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Created attachment 142637
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142637&action=edit
example firebird odb w/rowset object

This works for me with 6.1Beta1 (didn't try with 6.0.4)

1 set your options to allow macro execution

2 download the attached ODB w/firebird and open it

3 if asked enable macro execution

4 run the macro Main in the Standard library attached to the file

Sub Main

    oRS = createUnoService("com.sun.star.sdb.RowSet")
        oRS.DataSourceName = ThisComponent.Location
        oRS.CommandType = com.sun.star.sdb.CommandType.TABLE
        oRS.Command = "Business Contacts"
        oRS.Execute
        oRS.First
        msgbox "isFirst= " + oRS.isFirst

        oRS.Last

        msgbox "isFirst= " + oRS.isFirst

        oRS.Dispose()

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/20180610/a97a4e9b/attachment.html>