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

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.

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_mirowsky@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+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

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