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