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

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