Expand the screen and select the
block that you wish to modify.
Display the block properties. These
will either be displayed in Alphabetical or Logically, depending on the
setting of the [Sort Alphabetically/Logically] 
button. The following
instructions are assuming that the properties are sorted logically.
In the Name property, the name entered
during block creating is displayed, and can be changed, if desired.
In the Description property, enter
the user-defined description for the block.
In the Parent pop-list, if the parent
of this block is another block, the parent block is displayed, grayed
out. Otherwise, this pop-list is set to (entity
root).
In the Type pop-list, the original
setting from the block creation will be displayed, and can be changed,
if desired. The type can be Standard Block, Tab
Block, Chart Block, Bread Crumb, iFrame, or Basic Drag Drop. It
should be set to Basic Drag Drop.
In the Mutability pop-list, select
whether this block can be modified on screens that are created from this
template. This option is ONLY available for template
screens.
In the Query Type property, select
the type of query that this block will execute against the database. Choices
are Simple Query, Complex Query, and Xephr Interconnect.
Simple Query indicates that the block is taken from a simple query
to a database table/view. The Simple Query option
will be chosen most often for database blocks. The database query will
be constructed from the entries in the additional properties.
In the Table property, the original
value from block creation is displayed, but can be changed if desired.
Select the desired table/view from which the data
will be displayed on this block.
In the Datasource pop-list, the
original value from block creation is displayed, but can be changed, if
desired. Selecting (use default) will allow the
screen or template to be used with any datasource, and data brought in
will be determined by the screen's or template's datasource.
In the Number of Containers property,
enter the total number of containers that will be displayed in the block,
between which the records can be moved.
In the Container Id Column property,
select the column from the table that is used to store the container ID
for the record. The container ID determines in
which container the record will be placed when the block is loaded and
is updated when records are moved between containers.
In the X Column property, select
the column from the table that is used to store the location in pixels
of the top left corner of the record on the X axis (horizontal) of the
container to which the record has been assigned.
In the Y Column property, select
the column from the table that is used to store the location in pixels
of the top left corder of the record on the Y axis (vertical) of the container
to which the record has been assigned.
Set the Collapsible property to
the desired setting. When this property is set
to true, at runtime the detail block can be collapsed so that the entire
detail block is hidden or can be expanded and displayed. When
this property is set to false, the detail block cannot be hidden and expanded
and will always be displayed.
If the Collapsible property is set
to true, set the Initial State property to the desired setting. When
set to Collapsed, the records will be loaded on the block with the detail
block collapsed and hidden. When set the Expanded,
the records will be loaded on the block with the detail block expanded
and displayed.
In the Read Only Containers (comma
separated) property, enter the container numbers that are read only for
the Drag Drop block, separated by commas. Records
in read only containers cannot be dragged from the container and dropped
into another container. In addition, records from
other containers cannot be dropped into a read only container.
For example, if you had a five container drag drop block, and containers
1 and 5 were read only, you would enter 1,5 in this property.
In the Content Constraint List (comma
separated) property, enter the number of records that each container can
contain, separated be commas. The position of the
value corresponds to which container is restricted. If
the field is left blank, then all columns are unconstrained.
For example, if you had a five container drag drop block, and container
1 was restricted to 10 records, containers 2 through 4 were unrestricted,
and container 5 was restricted to 25 records, you would enter 10,,,,25.
In the Container Widths (comma separated)
property, enter the width of each container, separated by commas. The
position of the values corresponds to the container for which you are
defining the width. The container widths are relative
to the values that you enter here and the width defined for the block.
The values entered are added up and the width of
the block is divided by that value, then the appropriate width is applied
to each container. If no values are entered here,
all columns are assumed to be the same width.
For example, if you had a three container property, and you entered
1,1,3 in this field, these values would be added together to get 5, then
the width of the block would be divided by 5, and the first two containers
would be 1/5 of the width value wide, while the third column would be
3/5 of the width value wide.
In the Top Margin (in Pixels) property,
enter the number of pixels in the margin between the top of the container
and the top of the first record in the container.
In the Left Margin (in Pixels) property,
enter the number of pixels in the margin between the left side of the
container and the left side of the record in the container.
In the Horizontal Padding (in Pixels)
property, enter the number of pixels in between records horizontally within
a container.
In the Vertical Padding (in Pixels)
property, enter the number of pixels in between records vertically within
a container.
In the Select Statement property,
the automatically generated select statement for your database query is
displayed, beginning with the word SELECT. The
select statement lists the columns in the table or view from which the
data will be returned. Simple Query blocks will
have the data in this property generated automatically.
All columns selected from the database are explicitly named.
Format: SELECT column, column, column,
column FROM view
For example: SELECT item_no, description, stock_um, qty_on_hand FROM
item_master_uvw
In the Filters property, enter the
additional or overriding filters to restrict the information returned
by the select statement for this block, if appropriate. This
is also referred to as the where clause. The statement
begins with the word WHERE.
Format: WHERE column (comparison)
value AND column (comparison)
value
For example: WHERE qty_on_hand > 0 AND stock_um in ('FT','IN')
In the Ordering and Grouping property, enter any code to
be executed after the filters, such as the order by or group by. Not
from Query blocks will not have this property. This
property can be entered for both Simple Query and Complex Query types.
Format: ORDER BY column, column,
column
Format: GROUP BY column, column,
column
For example: ORDER BY description, stock_um, qty_on_hand desc
Set the Deletable property to determine
whether the data on this block can be deleted when the Delete function
is performed on the screen.
When this property is set to true,
and the Delete function is performed, the record(s) on the block will
be deleted from the database.
When this property is set to false,
and the Delete function is performed, the record(s) on the block will
not be deleted from the database.
In the Max Number of Rows property,
enter the maximum number of rows that will be retrieved and displayed
on the screen for this block. If this property
is set to 0, the repository default will be used from the Default Screen
Row Limit set up in the Repository Configuration.
A block is considered a list if the max number of rows is not set to
1.
Blocks are considered forms when the max number of rows is 1.
In the Wrap at Column property,
enter the number of records to be returned horizontally on the screen
before a line break is inserted and the next set is output on the next
row. This property allows you to have multiple
database rows returned horizontally on the screen.
For example, to return only one record per row on the block, enter
1 here and the block will look like this:
record 1
record 2
record 3
To return five records per row on the block, enter 5 here, and the
block will look like this:
record 1 record 2 record 3 record 4 record 5
record 6 record 7 record 8
In the Execute Before property,
enter any SQL statements that should be executed before the query for
this block is executed. Not from Query blocks will
not have this property.
Set the On QBE pop-list to true, if this block should be included
in QBE mode for this screen.
Set the On New pop-list to true, if this block should be included
in New mode for this screen.
Set the On List pop-list to true, if this block should be included
in List mode for this screen.
Set the On Edit pop-list to true, if this block should be included
in Edit mode for this screen.
Set the Display Only pop-list to
the desired setting to indicate whether the data on this block be displayed
as text only and cannot be modified.
When this pop-list is set to true,
the data will be displayed as text only and cannot be modified.
When this pop-list is set to false,
the data will be displayed as fields by default, but field level settings
can override this.
A list is considered to be editable if the block's Display Only pop-list
is set to false.
Set the Editability pop-list to
the desired setting to indicate when this block is editable.
Always Editable: the data on this block will be displayed in form fields,
and can be modified by default. This setting can
be overridden at the field level.
Editable on New Only: the data on this block will be displayed in form
fields and can be modified when the screen is in New mode only, by default.
This setting can be overridden to Never Editable
at the field level.
Never Editable: the data on this block will be displayed in form fields,
but cannot be modified.
Set the Body Style pop-list to the
style to be applied to the body for this block. If
set to (from parent), the style used will be the Body Style from the screen
properties.
Set the Editable Field Style pop-list
to the style to be applied by default to the editable fields for this
block. If set to (from parent), the style used
will be the Editable Field Style from the screen properties.
Set the Non-Editable Field Style
pop-list to the style to be applied by default to the display only and
label fields for this block. If set to (from parent),
the style used will be the Non-Editable Field Style from the screen properties.
Set the Link Style pop-list to the
style to be applied to hyperlinks for this block. If
set to (from parent), the style used will be the Link Style from the screen
properties.
In the X property, the location
in pixels is displayed for the top left corner of this block on the X-axis
(horizontal) of the layout screen. You can change
this number manually, or it will be changed when you are altering the
layout with the Designer Tool.
In the Y property, the location
in pixels is displayed for the top left corner of this block on the Y-axis
(vertical) of the layout screen. This value is
used in conjunction with the Y Anchor Type setting. You
can change this number manually, or it will be changed when you are altering
the layout with the Designer Tool.
In the Y Anchor Type pop-list, select
the anchor type for this block. Choices are Fixed
and Relative to Block..
In the Show if Empty pop-list, determine
whether the block will be displayed when it is empty. When
set to true, the block will be
displayed on the screen even when it contains no data. When
set to false, the block will be
hidden when it contains no data.
In the Z Order property, enter a
number to define the order in which the block will be generated on the
entity. The higher the number, the later the block
will be generated. The Z order is specific to the
indention level in the entity tree, and is affected by the Y Anchor and
Anchor Type properties.
For blocks with a Tab Block as the parent block, this number determines
in which order the tabs will be displayed within the tab block.
In the Commit Order property, enter
a number to define the order in which the data in the block will be committed
when the record is saved. The higher the number,
the later the block will be saved.
Set the Form is for QBE/NEW property
to the desired setting. The setting of this property
indicates to the system whether the block's defined query should be executed
and return the database results to the screen. For
new and QBE screens, since we are either entering a query against the
database, or inserting a row into the database, we do not want this to
happen.
If this block will be displayed on the screen in QBE or New mode, this
property should be set to true.
If the block will not be displayed on the screen in QBE or New mode,
this property should be set to false.
Edit and list blocks should always have this property
set to false, even if the block
definition contains new rows.
The Created on property displays the date and time on
which this block was created and cannot be changed.
The Modified on property displays the date and time
on which this block was last changed and cannot be modified.
When all changes have been made,
press the [Save] 
button in the Main Toolbar.
Expand the screen and select the
block that you wish to modify.
Display the block properties. These
will either be displayed in Alphabetical or Logically, depending on the
setting of the [Sort Alphabetically/Logically] button. The following
instructions are assuming that the properties are sorted logically.
In the Name property, the name entered
during block creating is displayed, and can be changed, if desired.
In the Description property, enter
the user-defined description for the block.
In the Parent pop-list, if the parent
of this block is another block, the parent block is displayed, grayed
out. Otherwise, this pop-list is set to (entity
root).
In the Type pop-list, the original
setting from the block creation will be displayed, and can be changed,
if desired. The type can be Standard Block, Tab
Block, Chart Block, Bread Crumb, iFrame, or Basic Drag Drop. It
should be set to Basic Drag Drop.
In the Mutability pop-list, select
whether this block can be modified on screens that are created from this
template. This option is ONLY available for template
screens.
In the Query Type property, select
the type of query that this block will execute against the database. Choices
are Simple Query, Complex Query, and Xephr Interconnect.
Complex Query indicates that the database query will be constructed
in its entirety by the user, such as when multiple tables must be referenced
for the data. The user will construct the database
query using these properties. Data on Complex Query blocks cannot be updated
to the database from the entity on Xephr Runtime unless the complex query
only references one table or view.
In the Datasource pop-list, the
original value from block creation is displayed, but can be changed, if
desired. Selecting (use default) will allow the
screen or template to be used with any datasource, and data brought in
will be determined by the screen's or template's datasource.
In the Number of Containers property,
enter the total number of containers that will be displayed in the block,
between which the records can be moved.
In the Container Id Column property,
enter the column from the complex query that is used to store the container
ID for the record. The container ID determines
in which container the record will be placed when the block is loaded
and is updated when records are moved between containers.
In the X Column property, select
the column from the table that is used to store the location in pixels
of the top left corner of the record on the X axis (horizontal) of the
container to which the record has been assigned.
In the Y Column property, select
the column from the table that is used to store the location in pixels
of the top left corder of the record on the Y axis (vertical) of the container
to which the record has been assigned.
Set the Collapsible property to
the desired setting. When this property is set
to true, at runtime the detail block can be collapsed so that the entire
detail block is hidden or can be expanded and displayed. When
this property is set to false, the detail block cannot be hidden and expanded
and will always be displayed.
If the Collapsible property is set
to true, set the Initial State property to the desired setting. When
set to Collapsed, the records will be loaded on the block with the detail
block collapsed and hidden. When set the Expanded,
the records will be loaded on the block with the detail block expanded
and displayed.
In the Read Only Containers (comma
separated) property, enter the container numbers that are read only for
the Drag Drop block, separated by commas. Records
in read only containers cannot be dragged from the container and dropped
into another container. In addition, records from
other containers cannot be dropped into a read only container.
For example, if you had a five container drag drop block, and containers
1 and 5 were read only, you would enter 1,5 in this property.
In the Content Constraint List (comma
separated) property, enter the number of records that each container can
contain, separated be commas. The position of the
value corresponds to which container is restricted. If
the field is left blank, then all columns are unconstrained.
For example, if you had a five container drag drop block, and container
1 was restricted to 10 records, containers 2 through 4 were unrestricted,
and container 5 was restricted to 25 records, you would enter 10,,,,25.
In the Container Widths (comma separated)
property, enter the width of each container, separated by commas. The
position of the values corresponds to the container for which you are
defining the width. The container widths are relative
to the values that you enter here and the width defined for the block.
The values entered are added up and the width of
the block is divided by that value, then the appropriate width is applied
to each container. If no values are entered here,
all columns are assumed to be the same width.
For example, if you had a three container property, and you entered
1,1,3 in this field, these values would be added together to get 5, then
the width of the block would be divided by 5, and the first two containers
would be 1/5 of the width value wide, while the third column would be
3/5 of the width value wide.
In the Top Margin (in Pixels) property,
enter the number of pixels in the margin between the top of the container
and the top of the first record in the container.
In the Left Margin (in Pixels) property,
enter the number of pixels in the margin between the left side of the
container and the left side of the record in the container.
In the Horizontal Padding (in Pixels)
property, enter the number of pixels in between records horizontally within
a container.
In the Vertical Padding (in Pixels)
property, enter the number of pixels in between records vertically within
a container.
In the Select Statement property,
enter the select statement for your database query, beginning with the
word SELECT. The select statement lists the columns
in the table or view from which the data will be returned. Complex
Query blocks require that the user enter the select statement.
All columns selected from the database need to be explicitly named.
Format: SELECT column, column, column,
column FROM view
For example: SELECT item_no, description, stock_um, qty_on_hand FROM
item_master_uvw
In the Filters property, enter the
additional or overriding filters to restrict the information returned
by the select statement for this block, if appropriate. This
is also referred to as the where clause. The statement
begins with the word WHERE.
Format: WHERE column (comparison)
value AND column (comparison)
value
For example: WHERE qty_on_hand > 0 AND stock_um in ('FT','IN')
If the block needs to be further restricted, such as by a global variable,
this is where you would enter the additional filters for that restriction.
For Complex Query blocks, the filters for your complex query are entered
here.
In the Ordering and Grouping property,
enter any code to be executed after the filters, such as the order by
or group by.
Format: ORDER BY column, column,
column
Format: GROUP BY column, column,
column
For example: ORDER BY description, stock_um, qty_on_hand desc
Set the Deletable property to determine
whether the data on this block can be deleted when the Delete function
is performed on the screen.
When this property is set to true,
and the Delete function is performed, the record(s) on the block will
be deleted from the database.
When this property is set to false,
and the Delete function is performed, the record(s) on the block will
not be deleted from the database.
In the Max Number of Rows property,
enter the maximum number of rows that will be displayed on the screen
for this block. If this property is set to 0, the
repository default will be used from the Default Screen Row Limit set
up in the Repository Configuration.
A block is considered a list if the max number of rows is not set to
1.
Blocks are considered forms when the max number of rows is 1.
In the Wrap at Column property,
enter the number of records to be returned horizontally on the screen
before a line break is inserted and the next set is output on the next
row. This property allows you to have multiple
database rows returned horizontally on the screen.
For example, to return only one record per row on the block, enter
1 here and the block will look like this:
record 1
record 2
record 3
To return five records per row on the block, enter 5 here, and the
block will look like this:
record 1 record 2 record 3 record 4 record 5
record 6 record 7 record 8
In the Execute Before property,
enter any SQL statements that should be executed before the query for
this block is executed. Not from Query blocks will
not have this property.
Set the On QBE pop-list to true, if this block should be included
in QBE mode for this screen.
Set the On New pop-list to true, if this block should be included
in New mode for this screen.
Set the On List pop-list to true, if this block should be included
in List mode for this screen.
Set the On Edit pop-list to true, if this block should be included
in Edit mode for this screen.
Set the Display Only pop-list to
the desired setting to indicate whether the data on this block be displayed
as text only and cannot be modified.
When this pop-list is set to true,
the data will be displayed as text only and cannot be modified.
When this pop-list is set to false,
the data will be displayed as fields by default, but field level settings
can override this.
A list is considered to be editable if the block's Display Only pop-list
is set to false.
Set the Editability pop-list to
the desired setting to indicate when this block is editable.
Always Editable: the data on this block will be displayed in form fields,
and can be modified by default. This setting can
be overridden at the field level.
Editable on New Only: the data on this block will be displayed in form
fields and can be modified when the screen is in New mode only, by default.
This setting can be overridden to Never Editable
at the field level.
Never Editable: the data on this block will be displayed in form fields,
but cannot be modified.
Set the Body Style pop-list to the
style to be applied to the body for this block. If
set to (from parent), the style used will be the Body Style from the screen
properties.
Set the Editable Field Style pop-list
to the style to be applied by default to the editable fields for this
block. If set to (from parent), the style used
will be the Editable Field Style from the screen properties.
Set the Non-Editable Field Style
pop-list to the style to be applied by default to the label and display
only fields for this block. If set to (from parent),
the style used will be the Non-Editable Field Style from the screen properties.
Set the Link Style pop-list to the
style to be applied to links for this block. If
set to (from parent), the style used will be the Link Style from the screen
properties.
In the X property, the location
in pixels is displayed for the top left corner of this block or field
on the X-axis (horizontal) of the layout screen. You
can change this number manually, or it will be changed when you are altering
the layout with the Designer Tool.
In the Y property, the location
in pixels is displayed for the top left corner of this block or field
on the Y-axis (vertical) of the layout screen. This
value is used in conjunction with the Y Anchor Type setting. You
can change this number manually, or it will be changed when you are altering
the layout with the Designer Tool.
In the Y Anchor Type pop-list, select
the anchor type for this block. Choices are Fixed
and Relative to Block..
In the Show if Empty pop-list, determine
whether the block will be displayed when it is empty. When
set to true, the block will be
displayed on the screen even when it contains no data. When
set to false, the block will be
hidden when it contains no data.
In the Z Order property, enter a
number to define the order in which the block will be generated on the
entity. The higher the number, the later the block
will be generated. The Z order is specific to the
indention level in the entity tree, and is affected by the Y Anchor and
Anchor Type properties.
For blocks with a Tab Block as the parent block, this number determines
in which order the tabs will be displayed within the tab block.
In the Commit Order property, enter
a number to define the order in which the data in the block will be committed
when the record is saved. The higher the number,
the later the block will be saved.
Set the Form is for QBE/NEW property
to the desired setting. The setting of this property
indicates to the system whether the block's defined query should be executed
and return the database results to the screen. For
new and QBE screens, since we are either entering a query against the
database, or inserting a row into the database, we do not want this to
happen.
If this block will be displayed on the screen in QBE or New mode, this
property should be set to true.
If the block will not be displayed on the screen in QBE or New mode,
this property should be set to false.
Edit and list blocks should always have this property
set to false, even if the
block definition contains new rows.
The Created on property displays the date and time on
which this block was created and cannot be changed.
The Modified on property displays the date and time
on which this block was last changed and cannot be modified.
When all changes have been made,
press the [Save] button in the Main
Toolbar.
Expand the screen and select the
block that you wish to modify.
Display the block properties. These
will either be displayed in Alphabetical or Logically, depending on the
setting of the [Sort Alphabetically/Logically] button. The following
instructions are assuming that the properties are sorted logically.
In the Name property, the name entered
during block creating is displayed, and can be changed, if desired.
In the Description property, enter
the user-defined description for the block.
In the Parent pop-list, if the parent
of this block is another block, the parent block is displayed, grayed
out. Otherwise, this pop-list is set to (entity
root).
In the Type pop-list, the original
setting from the block creation will be displayed, and can be changed,
if desired. The type can be Standard Block, Tab
Block, Chart Block, Bread Crumb, iFrame, or Basic Drag Drop. It
should be set to Basic Drag Drop.
In the Mutability pop-list, select
whether this block can be modified on screens that are created from this
template. This option is ONLY available for template
screens.
In the Query Type property, select
the type of query that this block will execute against the database. Choices
are Simple Query, Complex Query, and Xephr Interconnect.
Xephr Interconnect indicates that the query for this block will be
from a published entity on a Xephr host. This option
is only available if a Xephr Interconnect datasource exists.
In the Target Login property, the
user ID that will be used to access the published entity is displayed
and can be changed.
In the Target Password property,
e password that will be used to access the published entity is displayed
and can be changed.
In
the Datasource pop-list, the original value from block creation is displayed,
but can be changed, if desired.
The datasource for a Xephr Interconnect block must be a Xephr Interconnect
datasource. Only Xephr Interconnect datasources
will be displayed for selection for this property.
In
the Number of Containers property, enter the total number of containers
that will be displayed in the block, between which the records can be
moved.
In the Container Id Column property,
select the column from the table that is used to store the container ID
for the record. The container ID determines in
which container the record will be placed when the block is loaded and
is updated when records are moved between containers.
In the X Column property, select
the column from the table that is used to store the location in pixels
of the top left corner of the record on the X axis (horizontal) of the
container to which the record has been assigned.
In the Y Column property, select
the column from the table that is used to store the location in pixels
of the top left corder of the record on the Y axis (vertical) of the container
to which the record has been assigned.
Set the Collapsible property to
the desired setting. When this property is set
to true, at runtime the detail block can be collapsed so that the entire
detail block is hidden or can be expanded and displayed. When
this property is set to false, the detail block cannot be hidden and expanded
and will always be displayed.
If the Collapsible property is set
to true, set the Initial State property to the desired setting. When
set to Collapsed, the records will be loaded on the block with the detail
block collapsed and hidden. When set the Expanded,
the records will be loaded on the block with the detail block expanded
and displayed.
In the Read Only Containers (comma
separated) property, enter the container numbers that are read only for
the Drag Drop block, separated by commas. Records
in read only containers cannot be dragged from the container and dropped
into another container. In addition, records from
other containers cannot be dropped into a read only container.
For example, if you had a five container drag drop block, and containers
1 and 5 were read only, you would enter 1,5 in this property.
In the Content Constraint List (comma
separated) property, enter the number of records that each container can
contain, separated be commas. The position of the
value corresponds to which container is restricted. If
the field is left blank, then all columns are unconstrained.
For example, if you had a five container drag drop block, and container
1 was restricted to 10 records, containers 2 through 4 were unrestricted,
and container 5 was restricted to 25 records, you would enter 10,,,,25.
In the Container Widths (comma separated)
property, enter the width of each container, separated
by commas. The position of the values corresponds
to the container for which you are defining the width. The
container widths are relative to the values that you enter here and the
width defined for the block. The values entered
are added up and the width of the block is divided by that value, then
the appropriate width is applied to each container. If
no values are entered here, all columns are assumed to be the same width.
For example, if you had a three container property, and you entered
1,1,3 in this field, these values would be added together to get 5, then
the width of the block would be divided by 5, and the first two containers
would be 1/5 of the width value wide, while the third column would be
3/5 of the width value wide.
In the Top Margin (in Pixels) property,
enter the number of pixels in the margin between the top of the container
and the top of the first record in the container.
In the Left Margin (in Pixels) property,
enter the number of pixels in the margin between the left side of the
container and the left side of the record in the container.
In the Horizontal Padding (in Pixels)
property, enter the number of pixels in between records horizontally within
a container.
In the Vertical Padding (in Pixels)
property, enter the number of pixels in between records vertically within
a container.
In the Interconnect Entity property,
the original value from block creation is displayed, but can be changed
if desired. Select the published entity from which
the data will be displayed on this block. Choices
are determined by the datasource selected.
Depending on the Interconnect Entity
selected, one or more parameter (PARAM) properties will be displayed.
Enter the appropriate values for the parameters.
The parameters are used to restrict the values
returned from the published entity.
Set the Deletable property to determine
whether the data on this block can be deleted when the Delete function
is performed on the screen.
When this property is set to true,
and the Delete function is performed, the record(s) on the block will
be deleted from the database.
When this property is set to false,
and the Delete function is performed, the record(s) on the block will
not be deleted from the database.
In the Max Number of Rows property,
enter the maximum number of rows that will be displayed on the screen
for this block. If this property is set to 0, the
repository default will be used from the Default Screen Row Limit set
up in the Repository Configuration.
A block is considered a list if the max number of rows is not set to
1.
Blocks are considered forms when the max number of rows is 1.
In the Wrap at Column property,
enter the number of records to be returned horizontally on the screen
before a line break is inserted and the next set is output on the next
row. This property allows you to have multiple
database rows returned horizontally on the screen.
For example, to return only one record per row on the block, enter
1 here and the block will look like this:
record 1
record 2
record 3
To return five records per row on the block, enter 5 here, and the
block will look like this:
record 1 record 2 record 3 record 4 record 5
record 6 record 7 record 8
In the Execute Before property,
enter any SQL statements that should be executed before the query for
this block is executed. Not from Query blocks will
not have this property.
Set the On QBE pop-list to true, if this block should be included
in QBE mode for this screen.
Set the On New pop-list to true, if this block should be included
in New mode for this screen.
Set the On List pop-list to true, if this block should be included
in List mode for this screen.
Set the On Edit pop-list to true, if this block should be included
in Edit mode for this screen.
Set the Display Only pop-list to
the desired setting to indicate whether the data on this block be displayed
as text only and cannot be modified.
When this pop-list is set to true,
the data will be displayed as text only and cannot be modified.
When this pop-list is set to false,
the data will be displayed as fields by default, but field level settings
can override this.
A list is considered to be editable if the block's Display Only pop-list
is set to false.
Set the Editability pop-list to
the desired setting to indicate when this block is editable.
Always Editable: the data on this block will be displayed in form fields,
and can be modified by default. This setting can
be overridden at the field level.
Editable on New Only: the data on this block will be displayed in form
fields and can be modified when the screen is in New mode only, by default.
This setting can be overridden to Never Editable
at the field level.
Never Editable: the data on this block will be displayed in form fields,
but cannot be modified.
Set the Body Style pop-list to the
style to be applied to the body for this block. If
set to (from parent), the style used will be the Body Style from the screen
properties.
Set the Editable Field Style pop-list
to the style to be applied by default to the editable fields for this
block. If set to (from parent), the style used
will be the Editable Field Style from the screen properties.
Set the Non-Editable Field Style
pop-list to the style to be applied by default to the display only and
label fields for this block. If set to (from parent),
the style used will be the Non-Editable Field Style from the screen properties.
Set the Link Style pop-list to the
style to be applied to hyperlinks for this block. If
set to (from parent), the style used will be the Link Style from the screen
properties.
In the X property, the location
in pixels is displayed for the top left corner of this block or field
on the X-axis (horizontal) of the layout screen. You
can change this number manually, or it will be changed when you are altering
the layout with the Designer Tool.
In the Y property, the location
in pixels is displayed for the top left corner of this block or field
on the Y-axis (vertical) of the layout screen. This
value is used in conjunction with the Y Anchor Type setting. You
can change this number manually, or it will be changed when you are altering
the layout with the Designer Tool.
In the Y Anchor Type pop-list, select
the anchor type for this block. Choices are Fixed
and Relative to Block..
In the Show if Empty pop-list, determine
whether the block will be displayed when it is empty. When
set to true, the block will be
displayed on the screen even when it contains no data. When
set to false, the block will be
hidden when it contains no data.
In the Z Order property, enter a
number to define the order in which the block will be generated on the
entity. The higher the number, the later the block
will be generated. The Z order is specific to the
indention level in the entity tree, and is affected by the Y Anchor and
Anchor Type properties.
For blocks with a Tab Block as the parent block, this number determines
in which order the tabs will be displayed within the tab block.
In the Commit Order property, enter
a number to define the order in which the data in the block will be committed
when the record is saved. The higher the number,
the later the block will be saved.
Set the Form is for QBE/NEW property
to the desired setting. The setting of this property
indicates to the system whether the block's defined query should be executed
and return the database results to the screen. For
new and QBE screens, since we are either entering a query against the
database, or inserting a row into the database, we do not want this to
happen.
If this block will be displayed on the screen in QBE or New mode, this
property should be set to true.
If the block will not be displayed on the screen in QBE or New mode,
this property should be set to false.
Edit and list blocks should always have this property
set to false, even if the block
definition contains new rows.
The Created on property displays the date and time on
which this block was created and cannot be changed.
The Modified on property displays the date and time
on which this block was last changed and cannot be modified.
When all changes have been made,
press the [Save] button in the Main Toolbar.
Xephr is a registered trademark of NDS Systems, LC.