Browser displayer

User of process D2000 HI can work with structures (objects of Structured variable and Database table type) in two ways - by means of dialog box or displayer of Browser type placed in the picture.

This graphic object allows to use Drag&Drop feature for moving a content by mouse.

An example of Browser displayed in D2000 HI:

To create Browser displayer

1. In the Drawing toolbar, click the button Browser .
2. Point the mouse cursor to the position of the first displayer corner and click.
3. Point the mouse cursor to the position of the diagonal displayer corner and click.

The parameters of Browser displayer can be configured in the palette Connect object through the following tabs:

Connect

View object

Choice of a structure (local variable, structured variable or table), that is to be displayed by the Browser.

Note relating to D2000 Thin Client

Thin Client is able to display a structured variable and table. Data are not possible to be be edited (you can set them but the change will not be done).
For more rules see the page Drawing rules and object properties for D2000 Thin Client.

Controlled object

The parameter Controlled object row is optional. If a controlled object is defined, it (Structured variable) must contain the same structure definition as the displayed object. A defined row of the controlled structure will obtain values according to the currently displayed row. If any row is not selected, the last set values remain in the items in the row of controlled structure variable.

Note relating to D2000 Thin Client

The parameter is not supported in Thin Client.
For more rules see the page Drawing rules and object properties for D2000 Thin Client.

Controlled object row

This parameter specifies which row of the controlled object will alter its value. Such an object can be used as e.g. an input parameter for an Event executing some activity according to a row selection in the Browser.

Script

Reference variable

Specifies the name of the displayer in form of reference variable for use in the picture script.

Metadata

Application data (metadata) can be assigned to each graphic object and to column of Browser displayer in the System D2000 application. If the object contains some metadata, the name of the first record will be displayed in the button. Multiple records are indicated by ",...".

Event

The listbox allows user to select an active picture event for the displayer. The listbox contains the following active picture events:

• OnBrowserClick
• OnColumnClick
• OnFetchDone
• OnItemChange
• OnItemDoubleClick
• OnItemSelect
• OnItemValidate
• OnMouseDown
• OnMouseEnter
• OnMouseLeave
• OnPageChange
• OnUserInput

Event Handler

The button opens the active picture script to define the active picture event specified by the parameter Event.

Note relating to D2000 Thin Client

Thin Client does not support the Event handler.
For more rules see the page Drawing rules and object properties for D2000 Thin Client.

Select

The tab Select may be used only for objects of Database table type and allows to define a selection condition and a sorting condition.

Initial query

If checked, the condition specified below is applied to the table immediately after opening a picture and the table is filled with the items matching the criteria. Otherwise, after opening a picture the table remains empty. The desired condition is still available, though. However, to be applied, the function %HI_RefreshData must be called.

Condition

The input edit box to define a selection condition. A result set will include the objects matching the given mask. Condition syntax is identical with the syntax of condition following the clause WHERE in the SQL command SELECT (e.g. NAME= 'Test' or VALUE < 32.5).
Entering the condition #empty# doesn't read any data into the Browser (it can be used to open a Browser, whose condition is generated automatically on opening the picture from the script).

Sorting

The input edit box to define a sorting condition. Selected rows will be sorted by given condition. Condition syntax is the same as the syntax of a condition following the clause ORDER BY of the SQL command SELECT (e.g. NAME - sorting by the column NAME in ascending order or VALUE DESC - sorting by the column VALUE in ascending order).

Parameters

Set of parameters depends on the type of connected object. For objects of Database table type all the parameters displayed in the figure above are enabled , for objects of Structured variable type, only the parameters Edit and Column descriptions are enabled.

Note relating to D2000 Thin Client

The rows can be neither deleted nor added in Thin Client.
For more rules see the page Drawing rules and object properties for D2000 Thin Client.

Look

The tab Look allows to define an appearance of the Browser.

Others

The tab Others contains other, not often used parameters.

The button Columns opens the following dialog box allowing to define parameters for displaying individual columns.

The buttons , , and allow changing the order of columns in the browser window.

The button All visible shows / hides all columns in the browser window.

The button All editable enables / disables editing values of all columns in the browser window.

Master browser and synchronization

Definition of a browser, which will be joined (synchronized) with the browser. Synchronization is related either to horizontal shifting (the parameter Horizontal) or to vertical shifting (the parameter Vertical) of the browser using scroll bars and to paging (parameter Paging). The paging will be synchronized only if the paging of synchronized browsers is enabled and the number of rows on pages is equal.