Sorry - that last email wen to the wrong mailing list - please disregard it here.
On Wed, Jan 16, 2019 at 1:14 PM Drew Jensen <drewjensen.in...@gmail.com> wrote: > Before I forget - the files used for to gather these runtime numbers are > found here: > https://gerrit.libreoffice.org/#/admin/projects/benchmark > > There are five xls files with an explanation as to what the spreadsheet is > evaluating. > > They are 4 years old it looks like but seem to be as good as I've found > for example files for this feature. > > Seems to me it might be worthwhile to offer them for download (maybe as a > zip file) and reference that download location in the video and/or > associated posting text. > > On Wed, Jan 16, 2019 at 1:06 PM Drew Jensen <drewjensen.in...@gmail.com> > 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