Libreoffice base 7.1.4.2/Ubuntu 21.4
I have and MYSQL database linked via ODBC connector.
mysql Ver 5.7.33, for FreeBSD12.2 (amd64)
and
mysql Ver 8.0.25, for FreeBSD12.2 (amd64)
I want simple form to display data from table “stocklist” filtered by keyword entered in a textfield above table control.
only way i managed to ahieve that is by adding secondary table, “stocksearch” and using it’s contents(always 1 row) in a query:
SELECT stocklist.part_no, stocklist.package, stocklist.bin, stocklist.line, stocklist.column1, stocklist.column2, stocklist.description, stocklist.order_no, stocklist.supplier, stocklist.number FROM stocklist, stocksearch WHERE stocklist.part_no LIKE CONCAT( ‘%’, stocksearch.term, ‘%’ ) OR stocklist.description LIKE CONCAT( ‘%’, stocksearch.term, ‘%’ ) ORDER BY stocklist.part_no ASC, stocklist.package ASC, stocklist.bin ASC, stocklist.line ASC, stocklist.column1 ASC
filtering works as a charm
but
As soon as I add second table to the query results become uneditable, even if do nothing with it.
mere existence of second table after FROM statement makes query results uneditable.
I tried virtually identical query in access and phpmyadmin and both give editable results.
Is such setup even possible in base? if so where do I begin?
and no , clicking trough several popups to get filers to work and expecting users(IT morons) to properly add wildcards to search phrase is not an acceptable solution, sorry.
After going trough some french tutorials(thanks google translate) I managed go get 2 table query give editable results on embedded tables.
Identical setup gives read only result with linked mysql tables.
At least with myODBC connector, direct connection driver for ubuntu 21.4 is utterly unstable.
