[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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+unsubscribe@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

References:
[libreoffice-users] Base/Firebird Queries broken"Paul D. Mirowsky" <p_mirowsky@bentaxna.com>
Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.