Handy Library Manager
 for Windows

.. > Library backup, restore, maintenance. > How to Organize, Execute SQL statements?

Organize, Execute SQL Statement (new in version 4.0)

You can prepare and execute a SQL statement. Handy Library Manager is using Firebird SQL database system.

  • Be careful when running SQL statements. You can easily modify or delete all records in your library databases by mistake.
  • Do not use any commands that change the structure of the database (add new or delete existing fields, rename field names, create new or delete existing tables).
  • Before you run any SQL statement, create a backup file.

The Run SQL Statement function supports the following:

  • prepare SQL statement and execute it
  • define SQL statement and save it for future use
  • select the SQL statement from the list and execute it
run sql command, how to access

Run SQL Statement, examples:
grade, update student grades
author, change format
call, use 3 letters from the last name

Copyright © 2022 · All Rights Reserved · PrimaSoft PC