Difference between revisions of "BROWSE"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 35: | Line 35: | ||
<field> [:R] | <field> [:R] | ||
| − | |||
| − | |||
[:C = <expC> | <@alias>,<expC>] | [:C = <expC> | <@alias>,<expC>] | ||
[:V = <expL> [F:] [:E = <expC>] | [:V = <expL> [F:] [:E = <expC>] | ||
| − | |||
| − | |||
[:H = <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 . | Each field in the <field list> may be followed by special handling options. A delimiter precedes each option, either : or . | ||
| Line 54: | Line 50: | ||
|- | |- | ||
|valign="top"|:R||Fields are read-only, so may be viewed, but not edited. | |valign="top"|:R||Fields are read-only, so may be viewed, but not edited. | ||
| − | |||
| − | |||
|- | |- | ||
|valign="top"|: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. | |valign="top"|: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. | ||
| Line 65: | Line 59: | ||
|- | |- | ||
|valign="top"|:P = <expC>||Sets the picture format to <expC>. For more information on picture template characters and picture formatting, see @...GET. | |valign="top"|:P = <expC>||Sets the picture format to <expC>. For more information on picture template characters and picture formatting, see @...GET. | ||
| − | |||
| − | |||
|- | |- | ||
|} | |} | ||
| Line 95: | Line 87: | ||
use example | use example | ||
browse fields title:c="Mr,Mrs,Ms",; | browse fields title:c="Mr,Mrs,Ms",; | ||
| − | last_name: | + | last_name:r,; |
first_name | first_name | ||
Revision as of 11:39, 13 October 2016
Contents
Purpose
Data grid
Syntax
BROWSE
[FIELDS <field list>]
[FOR <expL1>]
[NOACTIONBAR]
[NOAPPEND]
[NODELETE]
[NOEDIT | NOMODIFY]
[STYLE <expC1>]
[TITLE <expC2>]
See Also
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; } "
