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]
mnogoja...@aol.com [h]
cmkelley...@gmail.com [p]
linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls>
Meeting Your Information Needs. Virtually.
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
