You can prepare and execute a SQL statement. Handy Library Manager is using Firebird SQL database system.
The Run SQL Statement function supports the following:
UPDATE LIBRARY SET TYPE = REPLACE(TYPE,'Books','Book');
UPDATE LIBRARY SET TYPE = REPLACE(TYPE,'Paper Book','Book');
UPDATE LIBRARY SET TYPE = REPLACE(TYPE,'cds','CD');
UPDATE LIBRARY SET TYPE = REPLACE(TYPE,'dvds','DVD');
In this sample, four sql statements are executed. They will change error entries in the TYPE data field:
Question: I use the Grade field so that I can print out their barcodes by grade level. Then I can scan the barcode when each grade level comes to library. This is the first time I've had to change their grade level since using the program. I just couldn't remember what I did in previous years to advance them to the next grade. I will do it manually.
Answer: You can send your library backup file to us. We will review in what data field you store a student's grade level. Then, we will reply with the SQL statement. You can also check how to update student grades.
Handy Library Manager
Copyright © 2023 · All Rights Reserved · PrimaSoft PC