Handy Library Manager: run SQL statement, upgrade student grades

Library Software for Windows

Handy Library Manager
for Windows

Library Software / Handy Library Manager
Get Free Trial Buy Now

.. > Library backup, restore, maintenance. > Organize, Execute SQL Statement > How to modify student grades?

ask a question, report a problem, ...

Run SQL Example; update student grades (new in version 4.0)

You can use the Run SQL function to upgrade your students' grades. For example, in the Borrowers table, you store the student grade in the CUSTOM1 data field. You want to update your student data at the beginning of the new school year. It will involve:

delete last grade students (do it in the BORROWERS table)
upgrade grades for remaining students (use Run SQL Statement)
enter first-grade students (enter manually or use import)

run sql statement, upgrade student grades

After deleting the last grade students, you can use the following SQL statement (1) to upgrade student grades. The WHERE close (2) specifies which records are updated and what a new value is assigned.
Notes:
- The order of the update statements is critical in this case.
There are four grades stored in the CUSTOM1 data field: Grade 1, Grade 2, Grade 3, and Grade 4.