Error Access2Base DLookup with Firebird

Discussions about using 3rd party extension with OpenOffice.org
Post Reply
inizul
Posts: 8
Joined: Sat Aug 20, 2016 5:46 pm

Error Access2Base DLookup with Firebird

Post by inizul »

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 
:knock:

LibreOffice Version: 6.1.0.3 (x64)
Firebird embedded
Windows 10
Attachments
ErrorDlookup.png
ErrorDlookup.png (7.17 KiB) Viewed 2497 times
LibOffice 5.1.4.2 on Windows 7
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Error Access2Base DLookup with Firebird

Post by Villeroy »

Embedded Firebird is a mistake. Use anything else as a better database backend. Above all, you should not use embedded databases.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
JPL
Volunteer
Posts: 130
Joined: Fri Mar 30, 2012 3:14 pm

Re: Error Access2Base DLookup with Firebird

Post by JPL »

@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
Kubuntu 22.04 / LibO 7.5
Access2Base (LibO).
BaseDocumenter extension (LibO)
ScriptForge (LibO)
Documentation on https://help.libreoffice.org/latest/en- ... bPAR=BASIC
Post Reply