Re: [libreoffice-users] Base/Firebird Queries broken
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: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Base/Firebird Queries broken
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 'migration' tool as a test. One query I am testing is a join of 4 tables. Series Series Series Series Date Date Date Time Time Time Criterion: Series 134, Select True I do have Alias fields, but understand from net search that they are disregarded by Firebird. I have waited 5 minutes for the query to process, but it only results in a blank screen or not responding. Windows 7 64 bit. LibreOffice Version: 6.1.3.2 (x64) The query did work with HSQLDB. Any hint as to where I'm going wrong. Thanks Paul -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Base/Firebird Queries broken
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 True I do have Alias fields, but understand from net search that they are disregarded by Firebird. I have waited 5 minutes for the query to process, but it only results in a blank screen or not responding. Windows 7 64 bit. LibreOffice Version: 6.1.3.2 (x64) The query did work with HSQLDB. Any hint as to where I'm going wrong. Thanks Paul -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy