If you were to work directly with the database through Sybase or Microsoft software rather than through the Table Editor, you would use sentences, referred to as transaction statements, to find and modify table information. The Table Editor is designed so you do not have to know or use transaction statements.
For example, when you search in Circulation for a borrower, you point and click at a search option then enter the search string. Underneath, Sybase or Microsoft creates a transaction statement that yields the results. To search for borrowers whose record numbers are 45 or lower, this is the SQL statement:
select name from borrower where borrower# < 45
When searching in Horizon, you do not need to know the table and column names and how the information you want relates to the column (that is, whether the column that contains the information is less than or greater than that information, and so forth); you do need to know this when searching in the database through Sybase or Microsoft software.
Although the Table Editor does not let you use full SQL statements, it does provide a command for you to use basic “where” clauses—clauses that locate data from a table where a column contains certain information.
This is the where clause formula:
select row_name from table_name
where column_name = value
You only enter the second half of the formula (where column_name = value).
© 1998-2017 Sirsi Corporation