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:

Example - Browser displayer

To create Browser displayer


  1. In the Drawing toolbar, click the button Browser Button Browser displayer.
  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


Connect object palette

1Selection of an object of Structured variable or Database table types, which will be displayed in the Browser.
2Selection of a local variable, which will be displayed in the Browser.
3Selection of a structure to control.
4Selection of a local variable to control.


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


Connect object palette - tab 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:



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.

Connect object palette - Select tab

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


Connect object palette - Parameters tab

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.


ParameterMeaning
PagingEnables / disables paging controls.
Lines
Number of lines in displayed page. Empty value or value 0 means dynamic number of lines depending on the browser's height.
For objects of Database table type, the maximum number of lines is limited by a Database configuration parameter Maximum returned rows.
Note: For objects of Database table type. Even if a dynamic number of lines is configured (empty value or value 0), after the change of browser's height the browser doesn't automatically refresh its content with changed number of lines. Moreover, moving between the pages also uses the original page size. To use a new page size it is necessary to call the function %HI_RefreshData.
EditEnables / disables editing of the displayed object (view object).
InsertEnables / disables inserting new lines.
DeleteEnables / disables deleting the liines.
Column descriptionsShows / hides the column captions. Descriptions are defined by the configuration of the object of Structure definition type in the process D2000 CNF - the item Description for given column). If the parameter is not checked, there will be displayed column names.
Condition changeEnables / disables changing the selection and sorting conditions.
Show gridShows / hides the grid.
Show selectionShows / hides highlighting the active (selected) row.
Horizontal bordersShows/ hides the horizontal row dividing lines.
Vertical bordersShows / hides the vertical row dividing lines.
Show line numbersShows / hides the numbers of lines - first row.
SplitterThe parameter allows to split the Browser into independent sections using the horizontal or vertical splitters.
Show column headersShows / hides the row containing the column captions.
Transparent selectionShows / hides transparent highlighting the active (selected) row (it allows to show the row background color).
MultiselectAllows to select multiple lines.
Automatic refreshSets the automatic refresh in Browser displayer, if the object Table is connected to it.


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.

Colors:

ParameterMeaning
BackgroundBackground color
Index columnBackground color of the index column.
OddBackground color of odd lines.
EvenBackground color of even lines.
Extra rows drawingDraw extra rows below the data rows
Odd extraBackground color of extra odd lines.
Even extraBackground color of extra even lines.
InsertedBackground color of inserted values.
DeletedBackground color of deleted values.
ModifiedText color of modified values.
PagerPaging bar background color
SelectedCurrent row will be highlighted.

Style:

Connect object palette - Look tab

ParameterMeaning
Enable iconsIf the option is checked off, the icons may be set to the cells of browser by the function %HI_SetBrowserItemImage.
BorderBorder type (None, Thin, Sunken, Raised).
Horiz. scroll barDisplaying the horizontal scroll bar (Never, Automatic, Always).
Vertic. scroll barDisplaying the vertical scroll bar (Never, Automatic, Always).
Paging barEnables/disables a paging bar below browser (Never, Automatic, Always).
Paging buttonsEnables/disables buttons on paging bar below browser (Never, Automatic).


Header:

ParameterMeaning
Set heightIf the option is checked, it is possible to specify the height of the header.
Specialized drawingIf the option is checked, it is possible to specify the colors and borders used to draw the header.
Left borderAdjusting the width and color of the column heading border.
Right borderAdjusting the width and color of the column heading border.
Column separatorAdjusting the width and color of the column separator.
Index columnBackground color of the header index column

Others



The tab Others contains other, not often used parameters.

Connect object palette - Others tab

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

Configuration of the columns

ColumnMeaning
Visible orderThe order of structure columns for displaying in Browser window.
Order in the structureThe order of columns in the structure definition (the user cannot change it).
NameName in the structure definition.
CaptionColumn name to be displayed in the Browser window.
VisibleShows / hides the column in the Browser window.
EditableEnables / disables editing values of the column.
WidthColumn width. It may contain arbitrary values.
The values of 0 and -1 set the column width as follows:
  • 0 - sets the column width by the texts in the column as well as the column header
  • -1 - sets the column width by the texts in the column (text in the column header is ignored)
AlignText alignment in the columns.
Display
Defines the type to display the items in given column:
  1. Text - shows text in the items
  2. Text+Button - shows text with button in the items (e.g. )
  3. Checkbox - shows a checkbox for values of Boolean or Integer types. For values of Integer type, the behaviour of checkbox is following:
    • checkbox is not checked - invalid value or 0
    • checkbox is checked - valid value and differ from 0
Displ. paletteSelection of a display palette (double-clicking the item opens the list of display palettes).
If mark * is marked in cell, setting from status text of correspondent column is used for colour setting of the cell.
It's possible to enter number of column to the cell (according to the order in structure), from which the display palette is inherited to actual column
Trans. paletteSelection of a transformation palette (clicking the item opens the dropdown box containing defined transformation palettes)
Use status textSets the editing method of cells. If ticked off, the cells of the given column can be edited by using a list box that contains the status texts defined for the column. If not ticked, you may write a value directly to the text field.
Header background colorSets the color of header background (requires enabled "Specialized drawing" option)
Header text colorSets the color of text in header (requires enabled "Specialized drawing" option)
Header fontSets the font of header (requires enabled "Specialized drawing" option)
Header alignSets the alignment of text in header (requires enabled "Specialized drawing" option)
MetadataAllows to configure metadata in the dialog box. If the column contains some metadata, the name of the first record will be displayed in the table. Multiple records are indicated by ",...".


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.


Napíšte komentár