On Wed, Jan 16, 2019 at 2:46 PM Paul D. Mirowsky <p_mirow...@bentaxna.com>
wrote:

> When editing the query, it works using RunQuery (F5)
>
> After editing and it is working, I save the Query.
>
> Then clicking on the saved Query from main Query window results in error
> again.
>

IDK on that, haven't seen that particular problem before.

Did you say that the SQL statement will run with Run SQL Direct turned on?





>
> On 1/16/2019 1:06 PM, Drew Jensen wrote:
> > So, can you open that Query definition, the one that raised the error
> when
> > you double clicked on it, in design view and Run it and it works?
> >
> > Is that what you are saying?
> >
> > Thanks
> >
> >
> > On Wed, Jan 16, 2019 at 12:17 PM Paul D. Mirowsky <
> p_mirow...@bentaxna.com>
> > wrote:
> >
> >> 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.
> >>
> >> Add back in 134 to Series field.
> >>
> >> It works
> >>
> >> Save it and save the database.
> >>
> >> Double click on the query to run it.
> >>
> >> Result in:
> >>
> >>> Error code: 1
> >>>
> >>> firebird_sdbc error
> >>> *Dynamic SQL Error
> >>> *SQL error code = -104
> >>> *Invalid usage of boolean expression
> >>> caused by
> >>> 'isc_dsql_prepare'
> >> It appears that the run function is adding an operation that is not in
> >> Query Design view.
> >>
> >> Any suggestions?
> >>
> >> Thanks
> >>
> >> Paul
> >>
> >>
> >> On 1/15/2019 6:19 PM, Paul D. Mirowsky wrote:
> >>> 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 removed
> >>> them from the query. The error still occurs.
> >>>
> >>> I am taking this to mean that there is a boolean comparison happening
> >>> that is not in the SQL generated by Base.
> >>>
> >>> Is this possible?
> >>>
> >>> 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
> >>
>
> --
> 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
>

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

Reply via email to