[Koha] Forgiving all overdue fines

[Charles Kelley]

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 at aol.com [h]
    cmkelleymls at gmail.com [p]

    linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls>
    Meeting Your Information Needs. Virtually.