On 2022-11-04 06:08, David C. Rankin wrote:
On 11/2/22 16:25, Carlos E. R. wrote:
Fortunately the chap that was helping me knows this, and posted the code and instructions. Initially this failed, but he found out why, and now I have it working, and I just added the books that were still not in the database a few minutes ago.
That's awesome. Still seems like a convoluted way to have to interface with a database, but if you prefer having a utility do it instead of writing the html/php (or whatever interface you want to use), then all is good.
I see people complaining about things that are easy to do in M$ Base and not in LO Base, and now I am understanding why, besides those I already knew. And missing documentation about those complicated things. Like code.
I've always been wary of the wiggle-your-ear work-arounds like buttons that do nothing but add an empty record. SQL is pretty straight-forward and any app like LO should be able to handle an INSERT query without a lot of muss and fuss.
But I know noting of SQL, and not about to learn now. Still, you have to trigger when to run that SQL, and that's a button.
Bash (or any shell, but particularly bash with the string-handling parameter expansions) is really good at manipulating records in batch-mode 'mysql -b ...'. Depending on your needed to add an occasional record or query your database, simple alias or 2-line scripts work fine too.
If you know sql.
Glad you got your books added and working in something that will still be supported (unless they radically change it :)
That's the idea :-) -- Cheers / Saludos, Carlos E. R. (from 15.3 x86_64 at Telcontar)