Home / Library Software / Handy Library Manager / Tutorials: Custom Views, View Assistant

Handy Library Manager  for Windows

Help, how to topics > Custom Views > View Assistant, how to define simple view?


This topic explains:

  • how to create a simple custom view

The View Assistant window provides simple interface that allows you to build a customized view with data from one or two tables.

In this topic we explain how to create a simple view:
The view will use two tables: LIBRARY and LIB_COPIES.
The view will display four data fields: TITLE, AUTHOR from LIBRARY, and BARCODE, CALL from LIB_COPIES.
There will be simple filter for AUTHOR field.
Items will be ordered by CALL data field.


Click Join 2 Tables.

Select 1st table and select 2nd table.

View Assistant automatically selects Join Fields (for some tables join fields have to be selected from the list).

Click Select Data Fields tab.


Select data fields that will be displayed in your custom view (if A.* or B.* is selected then all fields will be displayed).

Click Update View to generate View Definition.


Click Filter Conditions tab (optional).

Define filters (filters will limit the number of records displayed to a certain range).

A filter can specify a criterion for one or more fields.

Click Update View to generate View Definition.


Click Order By tab (optional).

Define the sort field for your custom view.

Click Update View to generate View Definition.


Click OK in the View Assistant. It closes View Assistant and loads the newly defined view into the Custom View Definition box.

Click Display to activate the view.

Click Save View to save the view for future use.

If you know the Firebird SQL language you can enter or modify the definition.


Click Display to activate the view.


Questions:


Handy Library Manager

software
tour
features
try now
cloud

Copyright © 2017 · All Rights Reserved · PrimaSoft PC