Poser votre question

Profil de lonk - activité

2020-01-19 22:58:24 +0100 médaille reçue  Question populaire (source)
2020-01-19 19:14:26 +0100 médaille reçue  Question remarquable (source)
2020-01-15 08:06:34 +0100 marquée comme meilleure réponse Calc BASIC | How to call Function in other Library ?

Code

'Library1 Module1'
Option Explicit
Sub TestConnectingEmbeddedFirebird1
    Dim iBox%
    iBox = MB_YESNO + MB_DEFBUTTON2 + MB_ICONQUESTION
    If MsgBox ("Do you want to connect embedded Firebird database ?", iBox) = IDYES Then
        On Local Error GoTo CloseConn
        Dim db As Object : db = Library2.Module1.ConnectDatabase("firebird0")
        MsgBox "Embedded Firebird database connected"
        DisconnectDatabase(db)
        MsgBox "Embedded Firebird database disconnected"
    Else
        MsgBox "No embedded Firebird database connected"    
    End IF
    Exit Sub
CloseConn:
    MsgBox "Error " & Err & ": " & Error$ & " (line : " & Erl & ")"
    DisconnectDatabase(db)
End Sub

Sub TestConnectingEmbeddedFirebird2
    On Local Error GoTo CloseConn
    Dim db As Object : db = Library2.Module1.ConnectDatabase("firebird0")
    DisconnectDatabase(db)
    Exit Sub
CloseConn:
    MsgBox "Error " & Err & ": " & Error$ & " (line : " & Erl & ")"
    DisconnectDatabase(db)
End Sub

'Library2 Module1'
Option Explicit
Function ConnectDatabase(dbFilename$) As Object
    Dim dbContext   As Object   : dbContext     = createUNOService("com.sun.star.sdb.DatabaseContext")
    Dim oDataSource As Object   : oDataSource   = dbContext.GetByName(dbFilename)
    ConnectDatabase = oDataSource.GetConnection("","")'("Username","Password")
End Function

Sub TestConnectingEmbeddedFirebird1 or Sub TestConnectingEmbeddedFirebird2 sent the error message:

image description

image description

image description

image description

How can we call Function in other Library (and in order to connect embedded Firebird database) ?

C:\fakepath\0002.ods

2020-01-14 23:05:03 +0100 médaille reçue  Question populaire (source)
2020-01-14 06:41:10 +0100 question modifiée Calc BASIC | How to call Function in other Library ?

Calc BASIC | How to call Function in other Library ? 'Library1 Module1 Option Explicit Sub TestConnectingEmbedde

2020-01-14 06:38:49 +0100 question modifiée Calc BASIC | How to call Function in other Library ?

Calc BASIC | How to call Function in other Library ? 'Library1 Module1 Option Explicit Sub TestConnectingEmbeddedFirebi

2020-01-14 06:36:56 +0100 question modifiée Calc BASIC | How to call Function in other Library ?

Calc BASIC | How to call Function in other Library ? 'Library1 Module1 Option Explicit Sub TestConnectingEmbeddedFi

2020-01-14 06:36:18 +0100 question modifiée Calc BASIC | How to call Function in other Library ?

Calc BASIC | How to call Function in other Library ? 'Library1 Module1 Option Explicit Sub TestConnectingEmbeddedFirebi

2020-01-14 06:35:46 +0100 question modifiée Calc BASIC | How to call Function in other Library ?

Calc BASIC | How to call Function in other Library ? 'Library1 Module1 Option Explicit Sub TestConnectingEmbeddedFirebi

2020-01-14 06:35:14 +0100 question modifiée Calc BASIC | How to call Function in other Library ?

Calc BASIC | How to call Function in other Library ? 'Library1 'Module1 Option Explicit Sub TestConnectingEm

2020-01-14 06:31:36 +0100 question modifiée Calc BASIC | How to call Function in other Library ?

Calc BASIC | How to call Function in other Library ? 'Library1 'Module1 Option Explicit Sub TestConnectingEm

2020-01-14 06:28:43 +0100 question modifiée Calc BASIC | How to call Function in other Library ?

Calc BASIC | How to call Function in other Library ? 'Library1 'Module1 Option Explicit Sub TestConnectingEm

2020-01-14 06:28:08 +0100 question modifiée Calc BASIC | How to call Function in other Library ?

Calc BASIC | How to call Function in other Library ? 'Library1 'Module1 Option Explicit Sub TestConnectingEmbeddedFirebi

2020-01-08 14:18:41 +0100 médaille reçue  Question célèbre (source)
2020-01-08 02:46:45 +0100 a commenté une réponse How can query run faster ?

Dear @pierre-yves samyn, Thank you so much, queries run only 1 second instead of nearly 50 seconds and point EOF within

2020-01-08 02:18:21 +0100 marquée comme meilleure réponse How can query run faster ?

Regarding the attached Firebird database, running queries namely AccountCodeLevel123456b or AccountCodeLevel123456c takes nearly 50 seconds and going to EOF takes nearly 50 seconds more as well. Is it possible to make them run faster ?C:\fakepath\firebird0.odb

2020-01-07 20:31:30 +0100 médaille reçue  Question remarquable (source)
2020-01-07 15:24:44 +0100 médaille reçue  Question populaire (source)
2019-12-29 04:12:31 +0100 médaille reçue  Question populaire (source)
2019-12-28 09:14:05 +0100 question commentée VCL of LibreOffice

Dear @Opaque, [ root@localhost fedora002]# export SAL_USE_VCLPLUGIN=gtk3;libreoffice6.2 QStandardPaths: wrong ownershi

2019-12-28 09:09:23 +0100 question commentée VCL of LibreOffice

Dear @Opaque, Regarding Fedora 31 KDE Desktop/Spins and LibreOffice 6.2.8.2-2, export SAL_USE_VCLPLUGIN=gtk3;libreoffi

2019-12-28 08:59:05 +0100 médaille reçue  Question célèbre (source)
2019-12-26 16:30:55 +0100 médaille reçue  Question remarquable (source)
2019-12-26 10:27:48 +0100 médaille reçue  Question populaire (source)
2019-12-26 05:41:28 +0100 médaille reçue  Question remarquable (source)
2019-12-25 14:32:58 +0100 médaille reçue  Question populaire (source)
2019-12-25 14:30:23 +0100 médaille reçue  Question célèbre (source)
2019-12-23 08:19:11 +0100 question commentée Base : How to save font of Table ?

Dear @Ratslinger, Thank you so much for your support. Please forget it for it's not a big deal and in the future I will

2019-12-23 08:18:37 +0100 question commentée Base : How to save font of Table ?

Dear @Ratslinger, Thank you so much for your support. Please forget it for it's not a big deal and in the future I will

2019-12-21 13:06:18 +0100 médaille reçue  Question populaire (source)
2019-12-05 19:03:04 +0100 a commenté une réponse Base macro code (in Basic) to write to a UTF-8 text file

Dear @Ratslinger, Sorry for such a very short question, actually I'd like to open previously saved text file and add mo

2019-12-05 15:06:56 +0100 médaille reçue  Question populaire (source)
2019-12-05 14:15:23 +0100 marquée comme meilleure réponse Do remaining folders of uninstalled versions matter ?

Before getting settled on the version 6.2.8.2-2, I used to install and uninstall many versions previously.

Are these remaining folders after the uninstallation?

image description

image description

image description

image description

image description

Inside folder libreofficedev6.4 is the same as in folder libreoffice6.3 .

| Fedora 31 Workstation KDE Desktop Spins | LibreOffice 6.2.8.2-2 |

2019-12-05 10:32:13 +0100 question modifiée Do remaining folders of uninstalled versions matter ?

Do remaining folders of uninstalled versions matter ? Before getting settled on the version 6.2.8.2-2, I used to install

2019-12-05 10:14:30 +0100 a commenté une réponse Base macro code (in Basic) to write to a UTF-8 text file

Dear @Ratslinger, And how can we add more lines into the existing text files ?

2019-12-05 10:14:10 +0100 a commenté une réponse Base macro code (in Basic) to write to a UTF-8 text file

And how can we add more lines into the existing text files ?

2019-12-03 03:31:56 +0100 marquée comme meilleure réponse CalcBASIC: How to move cursor to 4 directions ?

In MS Excel VBA, they do like this.

And in LO Calc BASIC, how can we do like that ?