The Horizon Table Editor is an application that directly accesses your library’s database. It lets you list, select, and edit database tables without having to learn the Structured Query Language (SQL) that is used by Horizon. To understand the purpose and functions of the Table Editor, you must understand these concepts:
• | Table Editor. The Table Editor is an organized, graphical view of your library’s raw data. You view this raw data in the Table Editor in windows called views. Views are not tables in your database; they are simply a window or look into the table. (For more information on views, see About Introduction to Horizon Views .) |
You can display views in the Table Editor in these two forms:
• | Lists. Lists display the records as rows in the table. This sample window shows a list for the collection table: |
• | Edit records. Edit records expand a single row into greater detail. This sample window shows an edit record for a selected collection from the table: |
In addition to displaying views in the Table Editor, you can edit a table’s data in the Edit records in views. You can directly add or delete data in columns by editing fields in views. Before you change any views, you need to understand how tables are interconnected.
These interconnections must be considered when changing table data. (For example, the collection table uses information from the istat table and the call_type table.) Here is an example of the relationship between tables:
Figure 1-1: Table Interconnections
This interconnected relationship between tables has three results:
• | You must create some tables before other tables. In the example in Figure 1-1, data in the Call No. Type table and data in the Item Stat Class table must exist before you set up your collections. |
• | The Codes buttons on some tables let you work with several interconnected tables at once. For example, if an ISTAT that you need for setting up a collection does not yet exist, you can choose the Codes button in the Collection view and create the ISTAT. You can then enter that ISTAT in the field in the Edit Collection Codes window. |
• | When you edit or delete rows in one table, you may first need to edit or delete rows in linked tables. In effect, you work backwards when editing or deleting table data. In the example in Figure 1-1, to delete the ISTAT “Per Art,” you would first have to delete all collection table items that include the ISTAT “PerArt.” Then you could delete the “PerArt” ISTAT. |
Whenever you make a change to Horizon setup, you should exit Horizon and restart it on any workstation where you want the change to take effect.
This chapter explains these topics:
• | Opening a View in the Table Editor |
• | Using the List Search Window |
• | Doing a Compound Search |
• | Using SQL Statements in the Table Editor |
• | Table Editor Menu Options |
© 1998-2017 Sirsi Corporation