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

2019-01-15 Thread Alexander Thurgood
Le 15/01/2019 à 16:14, Paul D. Mirowsky a écrit : Hi Paul, > SELECT "Equipment"."ID", "Equipment"."P_Model", > "Equipment"."P_Model_No", "Equipment"."Power Meter", Check that the space in the field "Power Meter" isn't causing an issue. There was a known bug about spaces being misinterpreted

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

2019-01-15 Thread Paul D. Mirowsky
See below... On 1/15/2019 10:37 AM, Robert Großkopf wrote: Hi Paul, Have a look at "Ions-IM"."Select" = TRUE Did the migrationtool set the field "Select" to a BOOLEAN-field? Yes "Equipment"."Series" = 134 Did the migrationtool import the field as a INTEGER field? Not quite. Series is

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

2019-01-15 Thread Paul D. Mirowsky
I am receiving the following error when opening a query. firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104 *Invalid usage of boolean expression caused by 'isc_dsql_prepare' The table names are: Amps   Volts-High The two tables involved both have one boolean field each, so I

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

2019-01-15 Thread Paul D. Mirowsky
I have replaced blanks with underscores in field names in tables. I have removed alias named fields from queries. It did not appear to make a difference. I should note that tables Amps, Volts-High and  Volts-In have the same or more field names. As each table name is prefixed to a field, I

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

2019-01-15 Thread Alexander Thurgood
Le 16/01/2019 à 00:19, Paul D. Mirowsky a écrit : > Invalid usage of boolean expression This bug perhaps ? http://tracker.firebirdsql.org/browse/CORE-5367?page=com.atlassian.jira.plugin.ext.subversion%3Asubversion-commits-tabpanel Not sure which version of Firebird we are using in LO - 3.0.1

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

2019-01-15 Thread Robert Großkopf
Hi Paul, Have a look at > "Ions-IM"."Select" = TRUE Did the migrationtool set the field "Select" to a BOOLEAN-field? > "Equipment"."Series" = 134 Did the migrationtool import the field as a INTEGER field? There is no function in the query, only 4 tables connected ... The only possibility to

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

2019-01-15 Thread Paul D. Mirowsky
Here is the query... SELECT "Equipment"."ID", "Equipment"."P_Model", "Equipment"."P_Model_No", "Equipment"."Power Meter", "Equipment"."Power_No", "Equipment"."Ion Meter", "Equipment"."Ion_No", "Equipment"."Series", "Equipment"."Power Meter 2", "Equipment"."Power_No 2", "Equipment"."Power

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

2019-01-15 Thread Alexander Thurgood
Le 15/01/2019 à 00:23, Paul D. Mirowsky a écrit : > Any hint as to where I'm going wrong. Without the query definition, it is going to be like gazing into a crystal ball...all sorts of things might not work in the same way, the time values, the date values (especially if there are calculations),