Modifying Bread Crumb Blocks on Screens

This section includes:

Not from Query Bread Crumb Blocks

Simple Query Bread Crumb Blocks

Complex Query Bread Crumb Blocks

Xephr Interconnect Bread Crumb Blocks

Not From Query Bread Crumb 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 Bread Crumb.
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, 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.
In the Separator Type pop-list, select Text or Image to indicate what will be used to separate the fields on the block.
In the Separator property, enter the separator that will be used. If the Separator Type is set to Text, enter the text character in this property. If the Separator Type is set to Image, enter the file path from the Xephr server to the image that will be used.
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 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 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 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.
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.

Simple Query Bread Crumb 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 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 Bread Crumb.
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, 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 Separator Type pop-list, select Text or Image to indicate what will be used to separate the fields on the block.
In the Separator property, enter the separator that will be used. If the Separator Type is set to Text, enter the text character in this property. If the Separator Type is set to Image, enter the file path from the Xephr server to the image that will be used.
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 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 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 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.
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.

Complex Query Bread Crumb 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 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 Bread Crumb.
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, 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 Separator Type pop-list, select Text or Image to indicate what will be used to separate the fields on the block.
In the Separator property, enter the separator that will be used. If the Separator Type is set to Text, enter the text character in this property. If the Separator Type is set to Image, enter the file path from the Xephr server to the image that will be used.
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 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 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 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.
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 Interconnect Bread Crumb 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 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 Bread Crumb.
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, and Xephr Service.

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 Separator Type pop-list, select Text or Image to indicate what will be used to separate the fields on the block.
In the Separator property, enter the separator that will be used. If the Separator Type is set to Text, enter the text character in this property. If the Separator Type is set to Image, enter the file path from the Xephr server to the image that will be used.
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 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 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 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.
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.