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, ...

Backup, Maintanance
-  backup library
-  restore databases
-  restore library folder
-  restore a file sent by email
-  inventory control, audit
-  synchronize loans
>  run SQL command
   >  grade, update student grades
   -  author, change format
   -  call, use 3 letters from last name
-  empty library databases
-  reset library ids
-  change library name
-  install library template
-  create a new library
-  delete library
-  data audit log
-  handy library folders

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.