You can use the Run SQL function to set the value of the CALL data field.
For example, you can execute the SQL command so the CALL data field will contain three first letters from the author's last name. Later, you can include the CALL data field when you define your spine labels.
In this case, author entries are in the "last name, first name" format.
You can execute a command that takes the three first characters from the entry, changes them to upper cases, and saves them in the CALL data field.
UPDATE LIBRARY_NEW SET CALL = UPPER(SUBSTRING(AUTHOR from 1 for 3))
In this case, author entries are in the "first name last name" format.
You can execute a command that takes the three first characters from the "last name" part, changes them to upper cases, and saves them in the CALL data field.
Retrieves last name and saves into the CUSTOM2 data field:
UPDATE LIBRARY_NEW SET CUSTOM2 = SUBSTRING(AUTHOR from CHAR_LENGTH(AUTHOR)-(POSITION(' ' in REVERSE(AUTHOR))-2) for POSITION(' ' in REVERSE(AUTHOR)))
After reviewing values in the CUSTOM2, run this:
UPDATE LIBRARY_NEW SET CALL = UPPER(SUBSTRING(CUSTOM2 from 1 for 3))
Use the CUSTOM VIEW feature: you can define a SELECT statement to review results before you execute the SQL command that modifies data values. The SELECT definitions create and display a temporary table.
SELECT AUTHOR, UPPER(SUBSTRING(AUTHOR from 1 for 3)) AS CALL1 FROM LIBRARY_NEW
Handy Library Manager 4.4, review new features
Labels Printing Software for Windows
Library Web Search, review new web search
Library Search 4.0, review new desktop search
Getting started library video lessons
How to include library name on labels
Library, Data Entry Form Designer
Edit item or borrower data in the check-in/check-out window?
Link item lost fine with the PRICE data field?
Handy v3.2 supports letter tabs?
How to predefine library email messages?
How to update library data from the web with ISBN?
How to predefine library email messages?
Compilation of questions and answers from library requests will help you to make purchase decision.
How to verify if the item is checked out in the library main catalog window?
How to create a new record using Copy Selected Item?
Special Library, how to manage digital and paper document library?
What is the maximum number of library items?
Library Software for Small Libraries, Windows application
Handy Library Manager
small library software
library tour
library features
try now, download
cloud
library software reviews
Copyright © 2024 · All Rights Reserved · PrimaSoft PC