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

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 
'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

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