Error Access2Base DLookup with Firebird

Discussions about using 3rd party extension with OpenOffice.org

Error Access2Base DLookup with Firebird

Postby inizul » 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   Expand viewCollapse view
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 114 times
LibOffice 5.1.4.2 on Windows 7
inizul
 
Posts: 8
Joined: Sat Aug 20, 2016 5:46 pm

Re: Error Access2Base DLookup with Firebird

Postby Villeroy » 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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25703
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Extensions

Who is online

Users browsing this forum: No registered users and 3 guests