LibreOffice Base (28) User Parameter Part 2

We add wildcards to our user input query and use it to create a simple form with a user input parameter.

The downloads to go with this series can be found here:

[Luminalstasis]

Thank you for this tutorial series. It has helped me greatly.

[alanonsr]

+TheFrugalComputerGuy, is it possible to do a libreoffice query with a user input parameter whereas the parameter is pulled from a listbox or combobox? Perhaps using an unbound form to input the data and then a button to trigger the Query? (If we use your example you've got in this video, the user wants to select from a list instead of doing a bolean/wild card search.)

[Cameron]

Great series on LO Base Frugal. I just noticed that on your form one of your headings is overwritten in bold. This is a problem i have incurred also but have not found the solution on how to correct it. Any suggestions are most welcomed.

[ednanda]

Hello, i followed the tutorial, but when i try to run the query, it doesnt show any records. Is it a bug or else? im using LibreOffice Base 6.0.7, and my criterion is something like this:

'%' || :Name || '%'

[flambergoog]

I used this type of query and it works great until I enter null in the search box. It returns all rows when I do that. I tested the code and it essentially sends "%" in the where statement which will include all values. So if the user leaves the input empty it will just return everything. is there a way to avoid this.

[newlifeman]

I realize that this may be outside the scope of the tutorial, I’m following along with the tutorial. However, instead of using the default HSQLD, I’m connecting to a MySQL server on a different machine. I’m running into an issue with the following query

SELECT
*

FROM
`tbl_employees`

WHERE
`Last Name` LIKE '%' || :Please_Enter_a_LastName || '%'

This query returns all records in the database. I assume this is because I’m not using HSQLDB. Is there a way to code such statements so that it works with MySQL? I'm thinking that this is an issue with coding the SQL for MySQL.

A note on the Quotation marks, I'm actually using OpenOffice to do most of the tutorial, but have LibreOffice installed on another computer. Opening the same ODB file with LibreOffice returns the same results.

The following coding works fine, returning the desired results of names that have an 'a' or 'A'in them.

WHERE `First Name` LIKE '%a%'