This section includes:
Not from Query Standard Blocks
Xephr Interconnect Standard Blocks
In the Explorer Tree, locate the object for which you wish to modify a block.
Expand the Template Information object and select the template screen for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the screen for which you wish to modify a block.
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 creation 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, or iFrame. It should be set to Standard Block.
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.
When set to Fully Mutable, the block is placed on all screens that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all screens that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all screens that inherit from this template and cannot be modified in anyway.
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.
Not from Query indicates that the block is not created from a database
table/view. Header blocks that contain only labels
should have this pop-list set to Not from Query.
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 editable 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..
When set to Fixed, the upper left corner of this block will be placed a fixed number of pixels in relation to the upper left corner of the block's parent. The number of pixels is defined in the Y field for the block.
When set to Relative to Block, the upper left corner of this block will be placed a fixed number of pixels from the bottom edge of the specified block defined in the Y Anchor field. Example: if you want a particular block to appear immediately after another block which happens to be an Expandable block (and therefore you don't know where it will end on the entity).
In the Y Anchor property, select the block or field that will be used to determine the location of the block on the Y-axis. The property is only displayed when the Y Anchor Type pop-list is set to Block.
In the Width property, enter the width for the block in pixels.
In the Height property, enter the height for the block in pixels.
In the Expand Type pop-list, define the size of the block. Choices are Expandable, Fixed No Scroll Bars, and Fixed with Scroll Bars.
When set to Expandable, the block will be at least the size of the Width and Height values, but it can be larger.
When set to Fixed No Scroll Bars, the block will be the exact size defined using the Width and Height values.
When set to Fixed with Scroll Bars, the block will be the exact sized defined using the Width and Height values, but there will be a scroll bar that allows you to scroll up or down within the block or field.
Example: an address block on a report may be fixed size, while the block for the line items on an invoice will be expandable so that all line items will be visible when the report is generated.
In the Hide If property, enter the conditions under which this block will be hidden. The field will be visible on the block when the conditions are met. When an entry is made in this property, the Show If property will be hidden.
Expressions are entered in this field using formulas and are evaluated on the server side.
When the expression entered in this property evaluates to true, the field will be hidden. The evaluation of the expression occurs when the entity is generated, and not when the user is making modifications to fields on the block. (i.e. This does not "watch" user input in a field and dynamically show a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'Y'
Hide the block if the value of the active field on the vendor block
is set to Y when the block is generated.
Example: starts-with( $$CUST_NO$$,
'NDS')
Hide the block only if the customer number starts with NDS.
The code entered in this field can
also include and/or expressions:
And is indicated by two ampersands &&
Or is indicated by two vertical lines ||
Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Hide this block if the current entity is the MENU entity and the NEXTMENU
global value is set to MM.
Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Hide this block if the customer number global is set to NDS, or the
customer number global is null or doesn't exist.
In the Show If property, enter the conditions under which this block will be displayed. The block will be hidden when the conditions are met. When an entry is made in this property, the Hide If property will be hidden.
Expressions are entered in this field using formulas and are evaluated on the server side.
When the expression entered in this property evaluates to true, the field will be displayed. The evaluation of the expression occurs when the entity is generated, and not when the user is making modifications to fields on the block. (i.e. This does not "watch" user input in a field and dynamically hide a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'N'
The block will be displayed when the value of the active field on the
vendor block is N when the entity is generated.
Example: number( $$ORDER.TOTAL$$)
= 0
Displays the block if the value of the total field on the order block
is zero.
The code entered in this field can
also include and/or expressions:
And is indicated by two ampersands &&
Or is indicated by two vertical lines ||
Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Show this block if the current entity is the MENU entity and the NEXTMENU
global value is set to MM.
Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Show this block if the customer number global is set to NDS, or the
customer number global is null or doesn't exist.
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.
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.
In the Explorer Tree, locate the object for which you wish to modify a block.
Expand the Template Information object and select the template screen for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the screen for which you wish to modify a block.
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, or iFrame.
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.
When set to Fully Mutable, the block is placed on all screens that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all screens that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all screens that inherit from this template and cannot be modified in anyway.
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 Service indicates that the query for this block will be from
a xephr service. When Xephr Service is selected,
the Datasource and Table properties are displayed. These
properties are used to construct the information returned by the Xephr
service.
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 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.
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..
When set to Fixed, the upper left corner of this block will be placed a fixed number of pixels in relation to the upper left corner of the block's parent. The number of pixels is defined in the Y field for the block.
When set to Relative to Block, the upper left corner of this block will be placed a fixed number of pixels from the bottom edge of the specified block defined in the Y Anchor field. Example: if you want a particular block to appear immediately after another block which happens to be an Expandable block (and therefore you don't know where it will end on the entity).
In the Y Anchor property, select the block or field that will be used to determine the location of the block on the Y-axis. The property is only displayed when the Y Anchor Type pop-list is set to Block or Field.
In the Width property, enter the width for the block in pixels.
In the Height property, enter the height for the block in pixels.
In the Expand Type pop-list, define the size of the block. Choices are Expandable, Fixed No Scroll Bars, and Fixed with Scroll Bars.
When set to Expandable, the block will be at least the size of the Width and Height values, but it can be larger.
When set to Fixed No Scroll Bars, the block will be the exact size defined using the Width and Height values.
When set to Fixed with Scroll Bars, the block will be the exact sized defined using the Width and Height values, but there will be a scroll bar that allows you to scroll up or down within the block or field.
Example: an address block on a report may be fixed size, while the block for the line items on an invoice will be expandable so that all line items will be visible when the report is generated.
In the Hide If property, enter the conditions under which this block will be hidden. The field will be visible on the block when the conditions are met. When an entry is made in this property, the Show If property will be hidden.
Expressions are entered in this field using formulas and are evaluated on the server side.
When the expression entered in this property evaluates to true, the field will be hidden. The evaluation of the expression occurs when the entity is generated, and not when the user is making modifications to fields on the block. (i.e. This does not "watch" user input in a field and dynamically show a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'Y'
Hide the block if the value of the active field on the vendor block
is set to Y when the block is generated.
Example: starts-with( $$CUST_NO$$,
'NDS')
Hide the block only if the customer number starts with NDS.
The code entered in this field can
also include and/or expressions:
And is indicated by two ampersands &&
Or is indicated by two vertical lines ||
Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Hide this block if the current entity is the MENU entity and the NEXTMENU
global value is set to MM.
Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Hide this block if the customer number global is set to NDS, or the
customer number global is null or doesn't exist.
In the Show If property, enter the conditions under which this block will be displayed. The block will be hidden when the conditions are met. When an entry is made in this property, the Hide If property will be hidden.
Expressions are entered in this field using formulas and are evaluated on the server side.
When the expression entered in this property evaluates to true, the field will be displayed. The evaluation of the expression occurs when the entity is generated, and not when the user is making modifications to fields on the block. (i.e. This does not "watch" user input in a field and dynamically hide a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'N'
The block will be displayed when the value of the active field on the
vendor block is N when the entity is generated.
Example: number( $$ORDER.TOTAL$$)
= 0
Displays the block if the value of the total field on the order block
is zero.
The code entered in this field can
also include and/or expressions:
And is indicated by two ampersands &&
Or is indicated by two vertical lines ||
Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Show this block if the current entity is the MENU entity and the NEXTMENU
global value is set to MM.
Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Show this block if the customer number global is set to NDS, or the
customer number global is null or doesn't exist.
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.
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.
In the Explorer Tree, locate the object for which you wish to modify a block.
Expand the Template Information object and select the template screen for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the screen for which you wish to modify a block.
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, or iFrame. It should be set to Standard Block.
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.
When set to Fully Mutable, the block is placed on all screens that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all screens that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all screens that inherit from this template and cannot be modified in anyway.
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 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 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.
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
In the Query for New property, enter the select statement for this block in new mode to set the default value. However, it is recommended in most instances that you set the default values at the field level using the Default Value property of each field instead of setting them here.
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.
SQL statements entered here must be fully formed and call a procedure (not a function).
SQL statements entered here are only applicable to queries, and not to updates, deletes, or inserts.
In the Execute After property, enter any SQL statements that should be executed after all rows are returned for this block. Not from Query blocks will not have this property.
SQL statements entered here must be fully formed and call a procedure (not a function).
SQL statements entered here are only applicable to queries, and not to updates, deletes, or inserts.
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 New Rows First property
to the desired setting. This property is only displayed
when the Display Only property is set to false.
When this property is set to true
and the Num New Rows property is set to a value other than 0, the new
rows generated for the insert of new database records will be displayed
at the top, before the existing database rows.
When this property is set to false
and the Num New Rows property is set to a value other than 1, the new
rows generated for the insert of new database records will be displayed
at the bottom, after the existing database rows.
In the Num New Rows property, enter the number of new rows that should be generated on this block for the insert of new database records. If new records cannot be created on this entity, set this property to 0. This property is only displayed when the Display Only property is set to false.
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..
When set to Fixed, the upper left corner of this block will be placed a fixed number of pixels in relation to the upper left corner of the block's parent. The number of pixels is defined in the Y field for the block.
When set to Relative to Block, the upper left corner of this block will be placed a fixed number of pixels from the bottom edge of the specified block defined in the Y Anchor field. Example: if you want a particular block to appear immediately after another block which happens to be an Expandable block (and therefore you don't know where it will end on the entity).
In the Y Anchor property, select the block or field that will be used to determine the location of the block on the Y-axis. The property is only displayed when the Y Anchor Type pop-list is set to Block or Field.
In the Width property, enter the width for the block in pixels.
In the Height property, enter the height for the block in pixels.
In the Expand Type pop-list, define the size of the block. Choices are Expandable, Fixed No Scroll Bars, and Fixed with Scroll Bars.
When set to Expandable, the block will be at least the size of the Width and Height values, but it can be larger.
When set to Fixed No Scroll Bars, the block will be the exact size defined using the Width and Height values.
When set to Fixed with Scroll Bars, the block will be the exact sized defined using the Width and Height values, but there will be a scroll bar that allows you to scroll up or down within the block or field.
Example: an address block on a report may be fixed size, while the block for the line items on an invoice will be expandable so that all line items will be visible when the report is generated.
In the Hide If property, enter the conditions under which this block will be hidden. The field will be visible on the block when the conditions are met. When an entry is made in this property, the Show If property will be hidden.
Expressions are entered in this field using formulas and are evaluated on the server side.
When the expression entered in this property evaluates to true, the field will be hidden. The evaluation of the expression occurs when the entity is generated, and not when the user is making modifications to fields on the block. (i.e. This does not "watch" user input in a field and dynamically show a block; everything is locked in when the block is first output).
Example:
$$VENDOR.ACTIVE$$ = 'Y'
Hide the block if the value of the active field on the vendor block
is set to Y when the block is generated.
Example:
starts-with( $$CUST_NO$$, 'NDS')
Hide the block only if the customer number starts with NDS.
The
code entered in this field can also include and/or expressions:
And is indicated by two ampersands &&
Or is indicated by two vertical lines ||
Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Hide this block if the current entity is the MENU entity and the NEXTMENU
global value is set to MM.
Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Hide this block if the customer number global is set to NDS, or the
customer number global is null or doesn't exist.
In the Show If property, enter the conditions under which this block will be displayed. The block will be hidden when the conditions are met. When an entry is made in this property, the Hide If property will be hidden.
Expressions are entered in this field using formulas and are evaluated on the server side.
When the expression entered in this property evaluates to true, the field will be displayed. The evaluation of the expression occurs when the entity is generated, and not when the user is making modifications to fields on the block. (i.e. This does not "watch" user input in a field and dynamically hide a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'N'
The block will be displayed when the value of the active field on the
vendor block is N when the entity is generated.
Example: number( $$ORDER.TOTAL$$)
= 0
Displays the block if the value of the total field on the order block
is zero.
The code entered in this field can
also include and/or expressions:
And is indicated by two ampersands &&
Or is indicated by two vertical lines ||
Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Show this block if the current entity is the MENU entity and the NEXTMENU
global value is set to MM.
Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Show this block if the customer number global is set to NDS, or the
customer number global is null or doesn't exist.
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.
In the Explorer Tree, locate the object for which you wish to modify a block.
Expand the Template Information object and select the template screen for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the screen for which you wish to modify a block.
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, or iFrame. It should be set to Standard Block.
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.
When set to Fully Mutable, the block is placed on all screens that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all screens that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all screens that inherit from this template and cannot be modified in anyway.
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. 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 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 Query for New property, enter the select statement for this block in new mode to set the default value. However, it is recommended in most instances that you set the default values at the field level using the Default Value property of each field instead of setting them here.
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.
SQL statements entered here must be fully formed and call a procedure (not a function).
SQL statements entered here are only applicable to queries, and not to updates, deletes, or inserts.
In the Execute After property, enter any SQL statements that should be executed after all rows are returned for this block. Not from Query blocks will not have this property.
SQL statements entered here must be fully formed and call a procedure (not a function).
SQL statements entered here are only applicable to queries, and not to updates, deletes, or inserts.
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..
When set to Fixed, the upper left corner of this block will be placed a fixed number of pixels in relation to the upper left corner of the block's parent. The number of pixels is defined in the Y field for the block.
When set to Relative to Block, the upper left corner of this block will be placed a fixed number of pixels from the bottom edge of the specified block defined in the Y Anchor field. Example: if you want a particular block to appear immediately after another block which happens to be an Expandable block (and therefore you don't know where it will end on the entity).
In the Y Anchor property, select the block or field that will be used to determine the location of the block on the Y-axis. The property is only displayed when the Y Anchor Type pop-list is set to Block or Field.
In the Width property, enter the width for the block in pixels.
In the Height property, enter the height for the block in pixels.
In the Expand Type pop-list, define the size of the block. Choices are Expandable, Fixed No Scroll Bars, and Fixed with Scroll Bars.
When set to Expandable, the block will be at least the size of the Width and Height values, but it can be larger.
When set to Fixed No Scroll Bars, the block will be the exact size defined using the Width and Height values.
When set to Fixed with Scroll Bars, the block will be the exact sized defined using the Width and Height values, but there will be a scroll bar that allows you to scroll up or down within the block or field.
Example: an address block on a report may be fixed size, while the block for the line items on an invoice will be expandable so that all line items will be visible when the report is generated.
In the Hide If property, enter the conditions under which this block will be hidden. The field will be visible on the block when the conditions are met. When an entry is made in this property, the Show If property will be hidden.
Expressions are entered in this field using formulas and are evaluated on the server side.
When the expression entered in this property evaluates to true, the field will be hidden. The evaluation of the expression occurs when the entity is generated, and not when the user is making modifications to fields on the block. (i.e. This does not "watch" user input in a field and dynamically show a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'Y'
Hide the block if the value of the active field on the vendor block
is set to Y when the block is generated.
Example: starts-with( $$CUST_NO$$,
'NDS')
Hide the block only if the customer number starts with NDS.
The code entered in this field can
also include and/or expressions:
And is indicated by two ampersands &&
Or is indicated by two vertical lines ||
Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Hide this block if the current entity is the MENU entity and the NEXTMENU
global value is set to MM.
Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Hide this block if the customer number global is set to NDS, or the
customer number global is null or doesn't exist.
In the Show If property, enter the conditions under which this block will be displayed. The block will be hidden when the conditions are met. When an entry is made in this property, the Hide If property will be hidden.
Expressions are entered in this field using formulas and are evaluated on the server side.
When the expression entered in this property evaluates to true, the field will be displayed. The evaluation of the expression occurs when the entity is generated, and not when the user is making modifications to fields on the block. (i.e. This does not "watch" user input in a field and dynamically hide a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'N'
The block will be displayed when the value of the active field on the
vendor block is N when the entity is generated.
Example: number( $$ORDER.TOTAL$$)
= 0
Displays the block if the value of the total field on the order block
is zero.
The code entered in this field can
also include and/or expressions:
And is indicated by two ampersands &&
Or is indicated by two vertical lines ||
Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Show this block if the current entity is the MENU entity and the NEXTMENU
global value is set to MM.
Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Show this block if the customer number global is set to NDS, or the
customer number global is null or doesn't exist.
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.
In the Explorer Tree, locate the object for which you wish to modify a block.
Expand the Template Information object and select the template screen for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the screen for which you wish to modify a block.
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, or iFrame. It should be set to Standard Block.
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.
When set to Fully Mutable, the block is placed on all screens that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all screens that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all screens that inherit from this template and cannot be modified in anyway.
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 Query for New property, enter the select statement for this block in new mode to set the default value. However, it is recommended in most instances that you set the default values at the field level using the Default Value property of each field instead of setting them here.
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.
SQL statements entered here must be fully formed and call a procedure (not a function).
SQL statements entered here are only applicable to queries, and not to updates, deletes, or inserts.
In the Execute After property, enter any SQL statements that should be executed after all rows are returned for this block. Not from Query blocks will not have this property.
SQL statements entered here must be fully formed and call a procedure (not a function).
SQL statements entered here are only applicable to queries, and not to updates, deletes, or inserts.
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 New Rows First property
to the desired setting. This property is only displayed
when the Display Only property is set to false.
When this property is set to true
and the Num New Rows property is set to a value other than 0, the new
rows generated for the insert of new database records will be displayed
at the top, before the existing database rows.
When this property is set to false
and the Num New Rows property is set to a value other than 1, the new
rows generated for the insert of new database records will be displayed
at the bottom, after the existing database rows.
In the Num New Rows property, enter the number of new rows that should be generated on this block for the insert of new database records. If new records cannot be created on this entity, set this property to 0. This property is only displayed when the Display Only property is set to false.
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..
When set to Fixed, the upper left corner of this block will be placed a fixed number of pixels in relation to the upper left corner of the block's parent. The number of pixels is defined in the Y field for the block.
When set to Relative to Block, the upper left corner of this block will be placed a fixed number of pixels from the bottom edge of the specified block defined in the Y Anchor field. Example: if you want a particular block to appear immediately after another block which happens to be an Expandable block (and therefore you don't know where it will end on the entity).
In the Y Anchor property, select the block or field that will be used to determine the location of the block on the Y-axis. The property is only displayed when the Y Anchor Type pop-list is set to Block or Field.
In the Width property, enter the width for the block in pixels.
In the Height property, enter the height for the block in pixels.
In the Expand Type pop-list, define the size of the block. Choices are Expandable, Fixed No Scroll Bars, and Fixed with Scroll Bars.
When set to Expandable, the block will be at least the size of the Width and Height values, but it can be larger.
When set to Fixed No Scroll Bars, the block will be the exact size defined using the Width and Height values.
When set to Fixed with Scroll Bars, the block will be the exact sized defined using the Width and Height values, but there will be a scroll bar that allows you to scroll up or down within the block or field.
Example: an address block on a report may be fixed size, while the block for the line items on an invoice will be expandable so that all line items will be visible when the report is generated.
In the Hide If property, enter the conditions under which this block will be hidden. The field will be visible on the block when the conditions are met. When an entry is made in this property, the Show If property will be hidden.
Expressions are entered in this field using formulas and are evaluated on the server side.
When the expression entered in this property evaluates to true, the field will be hidden. The evaluation of the expression occurs when the entity is generated, and not when the user is making modifications to fields on the block. (i.e. This does not "watch" user input in a field and dynamically show a block; everything is locked in when the block is first output).
Example:
$$VENDOR.ACTIVE$$ = 'Y'
Hide the block if the value of the active field on the vendor block
is set to Y when the block is generated.
Example:
starts-with( $$CUST_NO$$, 'NDS')
Hide the block only if the customer number starts with NDS.
The
code entered in this field can also include and/or expressions:
And is indicated by two ampersands &&
Or is indicated by two vertical lines ||
Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Hide this block if the current entity is the MENU entity and the NEXTMENU
global value is set to MM.
Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Hide this block if the customer number global is set to NDS, or the
customer number global is null or doesn't exist.
In the Show If property, enter the conditions under which this block will be displayed. The block will be hidden when the conditions are met. When an entry is made in this property, the Hide If property will be hidden.
Expressions are entered in this field using formulas and are evaluated on the server side.
When the expression entered in this property evaluates to true, the field will be displayed. The evaluation of the expression occurs when the entity is generated, and not when the user is making modifications to fields on the block. (i.e. This does not "watch" user input in a field and dynamically hide a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'N'
The block will be displayed when the value of the active field on the
vendor block is N when the entity is generated.
Example: number( $$ORDER.TOTAL$$)
= 0
Displays the block if the value of the total field on the order block
is zero.
The code entered in this field can
also include and/or expressions:
And is indicated by two ampersands &&
Or is indicated by two vertical lines ||
Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Show this block if the current entity is the MENU entity and the NEXTMENU
global value is set to MM.
Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Show this block if the customer number global is set to NDS, or the
customer number global is null or doesn't exist.
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.
Copyright