Difference between revisions of "BROWSE"
From Lianjapedia
Yvonne.milne (Talk | contribs) (→See Also) |
Yvonne.milne (Talk | contribs) (→Description) |
||
Line 74: | Line 74: | ||
|valign="top"|FOR <condition>||Restricts the BROWSE to those records matching the <condition>. | |valign="top"|FOR <condition>||Restricts the BROWSE to those records matching the <condition>. | ||
|- | |- | ||
− | |valign="top"|NOACTIONBAR||Hides the actionbar at the bottom of the grid | + | |valign="top"|NOACTIONBAR||Hides the actionbar at the bottom of the grid. |
|- | |- | ||
|valign="top"|NOAPPEND||Disables the appending of new records into the table. | |valign="top"|NOAPPEND||Disables the appending of new records into the table. | ||
Line 82: | Line 82: | ||
|valign="top"|NOEDIT | NOMODIFY||Disables record editing, providing read-only access to the table. | |valign="top"|NOEDIT | NOMODIFY||Disables record editing, providing read-only access to the table. | ||
|- | |- | ||
− | |valign="top"|STYLE <expC1>||Specify the CSS style, <expC1>, to be used | + | |valign="top"|STYLE <expC1>||Specify the CSS style, <expC1>, to be used. |
|- | |- | ||
|valign="top"|TITLE <expC2>||Specify a title, <expC2> to be displayed. | |valign="top"|TITLE <expC2>||Specify a title, <expC2> to be displayed. |
Revision as of 10:49, 24 November 2021
Contents
Purpose
Data grid
Syntax
BROWSE
[FIELDS <field list>]
[FOR <expL1>]
[NOACTIONBAR]
[NOAPPEND]
[NODELETE]
[NOEDIT | NOMODIFY]
[STYLE <expC1>]
[TITLE <expC2>]
[CAPTION <expC2>]
[KEY <expr>]
[SPLITBAR]
See Also
SELECT, SELECT, SELECT(), SET DELETED, 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. |
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. |
TITLE <expC2> | Specify a title, <expC2> to be displayed. |
CAPTION <expC3> | The selection caption to be displayed. Use this for picklists |
SPLITBAR | Enable split screen editing. |
KEY <expr> | position (seek) to the specified key in the grid. |
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; } "