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? > >> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > >> Posting guidelines + more: > http://wiki.documentfoundation.org/Netiquette > >> List archive: http://listarchives.libreoffice.org/global/users/ > >> Privacy Policy: http://www.documentfoundation.org/privacy > >> > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > Privacy Policy: http://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ Privacy Policy: http://www.documentfoundation.org/privacy
