Hello, Raymund! In our latest exchange, on 25 Mch. 2022 at 08:01 [JST], I read this from you through the Koha Discussion Group: We do not have any write access to the tables and any database updates are
done by our support company. I understand they have a script they run to do the business.
I think what PTFS were offering was a simple report for us to run to provide that ‘report for posterity’, but I had already obtained those details when I asked senior management for approval to have the fines removed. They may also have wanted to see how big the job would be for their script.
I doubt very much if the report processor would accept UPDATE clauses, even if I was logged in as a user that had write access to the tables. I know I have to be very careful not to include words like UPDATE or DELETE when writing reports (say, in tips to users running a report where they have to enter something like a date range). Use of these bad words causes an error in the SQL.
I didn't think Koha would include SELECT, SET, DELETE, and UPDATE statements (and other SQL statements) because it's all too easy to damage or delete a large portion of the database. Even seasoned database professionals have been know to lose a large portion of their database. GUIs mitigate against that possible outcome even though it can still happen. Thanks for your response. -- よろしくお願いします。 -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk@aol.com [h] cmkelleymls@gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.