Expand the spreadsheet 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 property, the name
of the parent block of this block is displayed. If
this is the top level block in the hierarchy, the property will display
(entity root).
In the Type pop-list, Standard Block
will be displayed.
In the Mutability pop-list, select
whether this block can be modified on spreadsheets that are created from
this template. This option is ONLY available for
template spreadsheets.
Expand the spreadsheet 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 property, the name
of the parent block of this block is displayed. If
this is the top level block in the hierarchy, the property will display
(entity root).
In the Type pop-list, Standard Block
will be displayed.
In the Mutability pop-list, select
whether this block can be modified on spreadsheets that are created from
this template. This option is ONLY available for
template spreadsheets.
In the Datasource pop-list, the original value from block
creation is displayed, but can be changed, if desired.
The datasource for a Xephr Service block must be a Xephr service datasource.
Only Xephr service datasources will be displayed
for selection for this property.
In the Table property, the original
value from block creation is displayed, but can be changed if desired.
Select the Xephr service method from which the
data will be displayed on this block. Choices are
determined by the datasource selected.
Depending on the Table selected,
one or more parameter (PARAM) properties will be displayed. Enter
the appropriate values for the parameters. The
parameters assigned to each service type are used to restrict the values
returned from the Xephr service.
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.
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, but cannot be
modified.
When all changes have been made,
press the [Save] 
button in the Main Toolbar.
Expand the spreadsheet 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 property, the name
of the parent block of this block is displayed. If
this is the top level block in the hierarchy, the property will display
(entity root).
In the Type pop-list, Standard Block
will be displayed.
In the Mutability pop-list, select
whether this block can be modified on spreadsheets that are created from
this template. This option is ONLY available for
template spreadsheets.
In the Query Type property, select
the type of query that this block will execute against the database. Choices
are Not from Query, Simple Query, Complex Query Xephr Service, 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 Datasource pop-list, the
original value from block creation is displayed, but can be changed, if
desired. Selecting (use default) will allow the
spreadsheet or template to be used with any datasource, and data brought
in will be determined by the spreadsheet's or template's datasource.
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 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. Simple
Query blocks will have the data in this property generated automatically.
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.
Expand the spreadsheet 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 property, the name
of the parent block of this block is displayed. If
this is the top level block in the hierarchy, the property will display
(entity root).
In the Type pop-list, Standard Block
will be displayed.
In the Mutability pop-list, select
whether this block can be modified on spreadsheets that are created from
this template. This option is ONLY available for
template spreadsheets.
In the Query Type property, select
the type of query that this block will execute against the database. Choices
are Not from Query, Simple Query, Complex Query Xephr Service, 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.
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
spreadsheet or template to be used with any datasource, and data brought
in will be determined by the spreadsheet's or template's datasource.
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
In the Execute Before property,
enter any SQL statements that should be executed before the query for
this block is executed.
Expand the spreadsheet 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 property, the name
of the parent block of this block is displayed. If
this is the top level block in the hierarchy, the property will display
(entity root).
In the Type pop-list, Standard Block
will be displayed.
In the Mutability pop-list, select
whether this block can be modified on spreadsheets that are created from
this template. This option is ONLY available for
template spreadsheets.
In the Query Type property, select
the type of query that this block will execute against the database. Choices
are Not from Query, Simple Query, Complex Query Xephr Service, 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 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.
In the Execute Before property,
enter any SQL statements that should be executed before the query for
this block is executed.
Xephr is a registered trademark of NDS Systems, LC.