BROWSE

From Lianjapedia
Revision as of 11:39, 13 October 2016 by Yvonne.milne (Talk | contribs)

Jump to: navigation, search

Purpose

Data grid

Syntax

BROWSE

[FIELDS <field list>]

[FOR <expL1>]

[NOACTIONBAR]

[NOAPPEND]

[NODELETE]

[NOEDIT | NOMODIFY]

[STYLE <expC1>]

[TITLE <expC2>]

See Also

SELECT, SELECT, SELECT(), USE

Description

The BROWSE user-interface tool displays the records from the currently active table in a grid window.

Keyword Description
FIELDS <field list> The comma-separated <field list> enables you to: specify the order in which the specified fields display and incorporate special handling options for each field. Please see below for these options.

<field> [:R]

[:C = <expC> | <@alias>,<expC>]

[:V = <expL> [F:] [:E = <expC>]

[:H = <expC>]

[:P = <expC>]

Each field in the <field list> may be followed by special handling options. A delimiter precedes each option, either : or .

Option Description
:R Fields are read-only, so may be viewed, but not edited.
:C = <expC> | <@alias>,<expC> The Choicelist option associates a pulldown choicelist with a field. The choicelist may be either 'static': a string of comma-separated choices or 'dynamic': @alias,string or a SQL Select query.
:V = <expL> [:E = <expC>] [:F] Validates the field value based on the evaluation of <expL>. If <expL> returns true (.T.), the field value is considered valid. If <expL> returns false (.F.), the value is rejected and an error message displayed. If the :E option is specified, <expC> replaces the default error message. The validation is only enforced when the field value changes unless the :F option is used.

This option does not work on memo fields.

:H = <expC> Replaces the default field headings, field name or description, with the character expression <expC>.
:P = <expC> Sets the picture format to <expC>. For more information on picture template characters and picture formatting, see @...GET.


Keyword Description
FOR <condition> Restricts the BROWSE to those records matching the <condition>.
NOACTIONBAR Hides the actionbar at the bottom of the grid (from v3.1.0).
NOAPPEND Disables the appending of new records into the table.
NODELETE Disables record deletion.
NOEDIT | NOMODIFY Disables record editing, providing read-only access to the table.
STYLE <expC1> Specify the CSS style, <expC1>, to be used (from v3.1.0).
TITLE <expC2> Specify a title, <expC2> to be displayed.

Example

open database southwind
use example
browse fields title:c="Mr,Mrs,Ms",;
	last_name:r,;
	first_name
 
// Style keyword
open database southwind
use example
browse noactionbar ;
	style "* { selection-color:yellow; ;
		selection-background-color:black; ;
		gridline-color:green; ;
		background:black;color:yellow; ;
		} ;
	QTableView::item { background:lightgreen; } ;
	QHeaderView::section { background-color:green;color:white;border:0px; } "