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'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. 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. Glad you got your books added and working in something that will still be supported (unless they radically change it :) -- David C. Rankin, J.D.,P.E.