 |
|
Oracle Tips by Burleson |
Tabular Form Element
Display As
This attribute will dictate how the report column
is to be rendered. There are several options from which to choose.
Some of them are used most commonly in Reports and others are used in
Tabular Forms. Table 7.3 shows the options available as the Display
As attribute.
·
Element Width: Used to set the width of form elements
such as a text field.
·
Number of Rows: Used to set the height of a text area.
·
Element Attributes: Used to set attributes of form
elements.
For example, there is no way to set the
maxlengthfor a text field in a
tabular form column using the HTML DB development environment.
However, the maxlength can be set using JavaScript. The Element
Attributes field can be used for this by entering the following text
into the attribute.
onFocus="javascript:this.maxLength=20;"
·
Element Option Attributes: Used to set attributes for
radio buttons and checkboxes.
·
Default Type: This select list is used to set the type
of code to be used to set the default value of the report column. The
options are:
·
No Default: There is no default value specified for the
element.
·
Item (application or page item name): Set the default
value to the value of another page item, such as a text field. This
can also use any value in session state.
·
PL/SQL Expression of Function: With this, a PL/SQL
function returning the value is provided to set as the default or a
SQL expression to calculate the default.
·
Default: The default text or PL/SQL function used as
the default. If the PL/SQL Expression or Function is used, this text
will be embedded in the SQL as a column. Therefore the proper syntax
must be included. The syntax to use is:
( select sysdate from dual
with the parenthesis and no semi-colon
The text shown above
will be embedded in a SQL statement as:
select customer_id, customer_name,
( select sysdate from dual )
from . . .
·
Reference Table Owner: When using the column in a
tabular form and using automatic row processing, this attribute is
used to select the schema owner of the table being updated.
·
Reference Table Name: Used with the previous attribute,
this is the name of the table.
·
Reference Column Name: Used with the previous
attribute, this is the name of the column.
The reference attributes above will be explained
further in a later chapter about tabular forms.
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
