Apache OpenOffice Community Forum

Posted: **Fri Sep 07, 2018 12:59 pm**

Hello,
I have migrated an embedded database from HSQLDB to Firebird.
In this database I used the DLookup function of Access2Base and with HSQLDB it worked correctly.
Now with Firebird I get an SQL error when I use the (Access2Base) DLookup function:

Code: Select all

Sub IPF_ActualizarDenominacionComponente ()
  Dim sCodigo as string
  Dim sDenominacion as string
  
  sCodigo=getValue("Forms!InformePreserieFicha!codigo") 
  sDenominacion=Application.DLookup("[Denominacion]", "[piezas]","[Codigo]='" & scodigo & "'")
  '  [Application.]DLookup(expression, domain[, criteria][, orderclause]))
  setValue("Forms!InformePreserieFicha!Componente.Value", sDenominacion)
  
End Sub

LibreOffice Version: 6.1.0.3 (x64)
Firebird embedded
Windows 10

Posted: **Fri Sep 07, 2018 1:14 pm**

Embedded Firebird is a mistake. Use anything else as a better database backend. Above all, you should not use embedded databases.

Posted: **Thu Sep 20, 2018 7:06 pm**

@inizul,

Access2Base is not yet ready to fully support Firebird 3.0.

However the issue that you mentioned was corrected in july. The correction will be included in LO 6.2: see patch https://gerrit.libreoffice.org/gitweb?p ... f44126b2a0

Sorry for the (temporary) inconvenience.

JPL

Apache OpenOffice Community Forum

Error Access2Base DLookup with Firebird

Error Access2Base DLookup with Firebird

Re: Error Access2Base DLookup with Firebird

Re: Error Access2Base DLookup with Firebird