Ok, this is what happened.
Opening the "2 Amps to Volts-High by Series"
By main "Queries", right click and choose "Edit"
In view, changed 134 to '134'
Message: Warning The entered criterion cannot be
compared with this field.
Remove 134 from Series and hit enter.
<Edit><Run Query> results in all records
Add 134 to Series and hit enter.
<Edit><Run Query> results in just 134 Series records.
Query Design <Save >
Double left click on query name "2 Amps to Volts-High by Series"
Message: The data content could not be loaded.
Error code: 1
<More> firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Invalid usage of boolean expression
caused by
'isc_dsql_prepare'
By main "Queries", right click and choose "Edit in SQL view..."
Remove AND "Amps"."Series" = '134'
<Edit><Run Query> results in all records
Add AND "Amps"."Series" = '134'
<Edit><Run Query> results in just 134 Series records.
Remove Add AND "Amps"."Series" = '134' and add Add AND
"Amps"."Series" = 134
<Edit><Run Query> results in just 134 Series records.
Saved the query in multiple states
When ever I save the Query and double left click from main Query window
on "2 Amps to Volts-High by Series"
Results in error message:
<More> firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Invalid usage of boolean expression
caused by
'isc_dsql_prepare'
In effect, in either edit mode it works correctly.
The saved query always fails.
Hope this helps
Paul
On 1/17/2019 12:58 AM, Robert Großkopf wrote:
Hi Paul,
Ok, things are narrowing down on this issue.
I have a Query Design view in which I have a field Series set to 134.
I remove the 134 and press enter.
Run Query (F5)
It works.
Save it at this point. Don't switch back. Does this work?
Then try
"Equipment"."Series" = '134'
instead of
"Equipment"."Series" = 134
before.
Regards
Robert
--
To unsubscribe e-mail to: [email protected]
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
