Re: [libreoffice-users] Base/Firebird Queries broken

2019-01-14 Thread Robert Großkopf
Hi Paul, as Dan wrote: Post the code of the query (opening SQL-view and copy). There are functions, which will work in HSQLDB, but won't work, with the same name, in Firebird. Regrads Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community:

Re: [libreoffice-users] Base/Firebird Queries broken

2019-01-14 Thread Dan Lewis
To begin with, what is the query's SQL. Someone might be able to discover the problem from there. In addition, knowing the properties of each one of the tables could also help solve it. On 1/14/19 6:23 PM, Paul D. Mirowsky wrote: I have shifted one of my database to Firebird using the advanced

[libreoffice-users] Base/Firebird Queries broken

2019-01-14 Thread Paul D. Mirowsky
I have shifted one of my database to Firebird using the advanced 'migration' tool as a test. One query I am testing is a join of 4 tables. Series Series Series Series Date DateDate Time TimeTime Criterion: Series 134, Select