You can prepare and execute a SQL statement. Handy Equipment-Tool Manager is using Firebird SQL database system.
The Run SQL Statement function supports the following:
For example, you use our Handy Equipment-Tool Manager at school. Your borrowers are students. At the beginning of the new school year, you can run the SQL function to upgrade your students’ grades. 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:
Enter SQL statement into the SQL Statement box (1).
Click Execute SQL (2) to execute the statement from the SQL Statement box (1).
Click Save, Organize SQL (3) to save the SQL statement for future use.
Click on the Saved SQL Statements dropdown box (4) to select the previously saved SQL statement.
Questions:
Latest equipment tracking how to articles:
How to email overdue notices to borrowers?
How to predefine email messages?
How to set automated emails with your Gmail account?
How to set automated emails with your Office365 account?
How to display checked out items in the equipment main inventory?
How to modify due dates for the checked out equipment?
Customized check-out receipt, include all items.
How to send email messages to all equipment users?
How to print group-by reports where each group starts on a new page?
How to export data from a custom view?
How to print, email check-out receipts?
How to modify the grid (number of columns, column size, column position)?
Handy Equipment Management with Check In/Out:
Handy Equipment-Tool Manager
tour
features
try now
cloud
Equpiment, tool tracking software solutions:
- office inventory tracking with check in/out
- equipment tracking, tool crib tracking with check in/out
- av, media equipment with check in/out
- police equipment
- prison, equipment tracking with check in/out
- athletic, sport equipment tracking review
- calibration management software
library software packages (included with handy e-t software):
school library
church library
non-profit org. library
business library
community library
small public library
Copyright © 2023 · All Rights Reserved · PrimaSoft PC