Converter entities have two blocks, a standard block and an executable block. The standard block executes a query against the database table from which the data is obtained, while the executable block takes that data and converts it into the new database table.
The Standard Block must have a Z order of 1.
The Executable Block must have a Z order of 2.
In the Explorer Tree, locate the object to which you wish to add a block.
Expand the Template Information object and select the template converter to which you wish to add a block.
Expand the Group Information object and any sub-groups until you can select the converter to which you wish to add a block.
When modifying a block, find the desired converter , and then see Modifying Blocks on Converters.
There are options in adding a block to the converter at this point.
Right-click on the converter or template converter, hold your cursor over the Create option, and when the sub-menu is displayed, left-click on the Block option.
Left-click on the [New Block] button in the Main Toolbar.
Left-click on the File Menu. Left-click on the New option. Left-click on the Block option.
Press Alt+B on the keyboard.
The Adding New Block screen will be displayed.
In the Create block similar to pop-list, if you wish to create the block based on an existing block on the converter, select the desired block here. Otherwise, select (none). This option is only available if you are adding the block to an entity and not another block.
In the Block Name property, enter the name of the new block that you are adding to the converter.
In the Block Type property, select the type of block that you are creating. Choices are Standard Block and Executable Block.
The choices displayed are dependent on the Block Type selected.
In the Query Type property, select the type of query for the converter block. Choices are:
Simple Query: some or all of the fields in the block will be taken from a database query against a single database table or view.
Complex Query: some or all of the fields in the block will be taken from a database query against one or more database tables or views. Complex query blocks are display only or read only, and cannot be used to update the database.
Xephr Service: some or all of the fields in the block will be provided by a Xephr service. Can only be selected if there are Xephr Service datasources set up.
Xephr Interconnect: some or all of the fields in the block will be provided by a published entity through a Xephr Interconnect datasource. Can only be selected if there are Xephr Interconnect datasources set up.
In the Datasource property, select
the desired datasource or (use default).
Selecting (use default) will allow the block to be used with any datasource,
and data brought in will be determined by the converter's or template's
datasource.
If Xephr Service was selected, this pop-list will only list the datasources
that provide Xephr services.
If Xephr Interconnect was selected, this pop-list will only list the
Xephr Interconnect datasources.
If Simple Query was selected, in the Table pop-list, select the database table/view on which to base the block.
If Xephr Service was selected, in the Table pop-list, select the Xephr Service method on which to base the block. Choices are determined by the datasource selected.
If Xephr Interconnect was selected, in the Interconnect Entity pop-list, select the published entity on which to base the block. Choices are determined by the published entities on the datasource selected.
If Xephr Interconnect was selected, in the Target Login property, enter the user ID that will be used to access the published entity.
If Xephr Interconnect was selected, in the Target Password property, enter the password that will be used to access the published entity.
Click on the Next button in the bottom right of the screen to continue.
The information displayed next is dependent on the setting of the Query Type property.
A list of the columns in the selected table will be displayed.
Set the Key Required flag to the desired setting. This flag defaults to on, which indicates that at least one column that is selected must have the Key flag set to on. The Next button cannot be pressed until the key column is selected or this flag is set to off.
For each column, indicate whether
the column is a primary key for the view by setting the Key flag to on or off.
To set the Key flag for all displayed columns, left-click once on the
gray Key column header.
For each column, indicate whether
the column will be included as a field on this block by setting the Field
flag to on or off.
To set the Field flag for all displayed columns, left-click once on
the gray Field column header.
In the Filters property, enter
the filters used to restrict the information returned by the select statement
for the block, if appropriate. This is also referred
to as the where clause. The statement begins with
the word WHERE.
Format: WHERE column (comparison)
value AND column (comparison)
value
For example: WHERE qty_on_hand > 0 AND stock_um in ('FT','IN')
In the Ordering and Grouping property,
enter any code to be executed after the filters, such as the order by
or group by.
Format: ORDER BY column, column,
column
Format: GROUP BY column, column,
column
For example: ORDER BY description, stock_um, qty_on_hand desc
Press the Next button at the bottom of the screen.
The next step is to set up the order of the columns for the block. Using the Move Up and Move Down buttons, arrange the columns to be in the order that you wish them to be for the conversion.
Press the Next button at the bottom right of the screen to continue.
The next step is to create additional
joins if there are multiple blocks on the converter. If
you wish to create joins, set the Create Join flag to on.
Additional properties will be displayed to allow you to define the
joining column.
In the From Column property, select the column on the child block that
will be joined to the parent block.
In the To Block property, select the block that contains the column
to which the from column will be joined.
In the To Column property, select the column to which you are joining
the from column.
The join will be added to the block when the block is created. Joins
are created as equal joins automatically.
For more information on joins, see the Joining
Data on Blocks section.
Click on the Next button at the bottom right of the screen to continue.
At this point a new screen is displayed. If you wish to add another block, set the Add Block or Labels flag to on and press the Next button.
A new screen will be displayed to allow you to select whether you want to add another block to an existing block or the entity. Click on the desired object and press the Add Block button to continue to add blocks as described above.
The screen also allows you to add labels to a block. Click on the desired block and press the Add Labels button. The Adding New Labels screen will be displayed.
To add a new label, click on the Add button.
In the field that appears under the Fields section, enter the name of the Label and press the Enter key on your keyboard.
Repeat until you have entered all desired labels.
To delete a label that you have created, click on the desired label and press the Delete button.
When all desired labels have been entered, click on the Next button on the bottom right of the screen.
The labels will be added to the block.
Otherwise, press the Finish button in the bottom right of the screen.
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.
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 filters used to restrict the information returned by the select statement
for the block, if appropriate. This is also referred
to as the where clause. The statement begins with
the word WHERE.
Format: WHERE column (comparison)
value AND column (comparison)
value
For example: WHERE qty_on_hand > 0 AND stock_um in ('FT','IN')
In the Ordering and Grouping property,
enter any code to be executed after the filters, such as the order by
or group by.
Format: ORDER BY column, column,
column
Format: GROUP BY column, column,
column
For example: ORDER BY description, stock_um, qty_on_hand desc
Click on the Next button in the bottom right of the screen to continue.
A list of the columns in the selected table will be displayed.
Set the Key Required flag to the desired setting. This flag defaults to on, which indicates that at least one column that is selected must have the Key flag set to on. The Next button cannot be pressed until the key column is selected or this flag is set to off.
For each column, indicate whether
the column is a primary key for the view by setting the Key flag to on or off.
To set the Key flag for all displayed columns, left-click once on the
gray Key column header.
For each column, indicate whether
the column will be included as a field on this block by setting the Field
flag to on or off.
To set the Field flag for all displayed columns, left-click once on
the gray Field column header.
Press the Next button at the bottom of the screen.
The next step is to set up the order of the columns for the block. Using the Move Up and Move Down buttons, arrange the columns to be in the order that you wish them to be for the conversion.
Press the Next button at the bottom right of the screen to continue.
The next step is to create additional
joins if there are multiple blocks on the converter. If
you wish to create joins, set the Create Join flag to on.
Additional properties will be displayed to allow you to define the
joining column.
In the From Column property, select the column on the child block that
will be joined to the parent block.
In the To Block property, select the block that contains the column
to which the from column will be joined.
In the To Column property, select the column to which you are joining
the from column.
The join will be added to the block when the block is created. Joins
are created as equal joins automatically.
For more information on joins, see the Joining
Data on Blocks section.
Click on the Next button at the bottom right of the screen to continue.
At this point a new screen is displayed. If you wish to add another block, set the Add Block or Labels flag to on and press the Next button.
A new screen will be displayed to allow you to select whether you want to add another block to an existing block or the entity. Click on the desired object and press the Add Block button to continue to add blocks as described above.
The screen also allows you to add labels to a block. Click on the desired block and press the Add Labels button. The Adding New Labels screen will be displayed.
To add a new label, click on the Add button.
In the field that appears under the Fields section, enter the name of the Label and press the Enter key on your keyboard.
Repeat until you have entered all desired labels.
To delete a label that you have created, click on the desired label and press the Delete button.
When all desired labels have been entered, click on the Next button on the bottom right of the screen.
The labels will be added to the block.
Otherwise, press the Finish button in the bottom right of the screen.
A list of the columns for the selected Xephr method will be displayed.
For each column, indicate whether
the column is a primary key for the view by setting the Key flag to on or off.
To set the Key flag for all displayed columns, left-click once on the
gray Key column header.
For each column, indicate whether
the column will be included as a field on this block by setting the Field
flag to on or off.
To set the Field flag for all displayed columns, left-click once on
the gray Field column header.
Press the Next button at the bottom of the screen.
The next step is to set up the order of the columns for the block. Using the Move Up and Move Down buttons, arrange the columns to be in the order that you wish them to be for the conversion.
Press the Next button at the bottom right of the screen to continue.
The next step is to create additional
joins if there are multiple blocks on the converter. If
you wish to create joins, set the Create Join flag to on.
Additional properties will be displayed to allow you to define the
joining column.
In the From Column property, select the column on the child block that
will be joined to the parent block.
In the To Block property, select the block that contains the column
to which the from column will be joined.
In the To Column property, select the column to which you are joining
the from column.
The join will be added to the block when the block is created. Joins
are created as equal joins automatically.
For more information on joins, see the Joining
Data on Blocks section.
Click on the Next button at the bottom right of the screen to continue.
At this point a new screen is displayed. If you wish to add another block, set the Add Block or Labels flag to on and press the Next button.
A new screen will be displayed to allow you to select whether you want to add another block to an existing block or the entity. Click on the desired object and press the Add Block button to continue to add blocks as described above.
The screen also allows you to add labels to a block. Click on the desired block and press the Add Labels button. The Adding New Labels screen will be displayed.
To add a new label, click on the Add button.
In the field that appears under the Fields section, enter the name of the Label and press the Enter key on your keyboard.
Repeat until you have entered all desired labels.
To delete a label that you have created, click on the desired label and press the Delete button.
When all desired labels have been entered, click on the Next button on the bottom right of the screen.
The labels will be added to the block.
Otherwise, press the Finish button in the bottom right of the screen.
A list of the columns in the selected published entity will be displayed.
For each column, indicate whether
the column is a primary key for the entity by setting the Key flag to
on or off.
To set the Key flag for all displayed columns, left-click once on the
gray Key column header.
For each column, indicate whether
the column will be included as a field on this block by setting the Field
flag to on or off.
To set the Field flag for all displayed columns, left-click once on
the gray Field column header.
For each column, in the Format
pop-list, select the format mask for this field
from the list of pre-defined format masks.
Date fields must have a format mask entered. Format
masks can only be applied to date and numeric fields.
For more information, see the Format
Masks section.
Press the Next button at the bottom of the screen.
The next step is to set up the order of the columns for the block. Using the Move Up and Move Down buttons, arrange the columns to be in the order that you wish them to be for the conversion.
Press the Next button at the bottom right of the screen to continue.
At this point a new screen is displayed. If you wish to add another block, set the Add Block or Labels flag to on and press the Next button.
A new screen will be displayed to allow you to select whether you want to add another block to an existing block or the entity. Click on the desired object and press the Add Block button to continue to add blocks as described above.
The screen also allows you to add labels to a block. Click on the desired block and press the Add Labels button. The Adding New Labels screen will be displayed.
To add a new label, click on the Add button.
In the field that appears under the Fields section, enter the name of the Label and press the Enter key on your keyboard.
Repeat until you have entered all desired labels.
To delete a label that you have created, click on the desired label and press the Delete button.
When all desired labels have been entered, click on the Next button on the bottom right of the screen.
The labels will be added to the block.
Otherwise, press the Finish button in the bottom right of the screen.
In the Query Type property, select the type of query for the converter block. Choices are:
Simple Query: some or all of the fields in the block will be taken from a database query against a single database table or view.
Complex Query: some or all of the fields in the block will be taken from a database query against one or more database tables or views. Complex query blocks are display only or read only, and cannot be used to update the database.
Xephr Service: some or all of the fields in the block will be provided by a xephr service.
In the Datasource property, select
the desired datasource or (use default).
Selecting (use default) will allow the block to be used with any datasource,
and data brought in will be determined by the converter's or template's
datasource.
If Xephr Service was selected, this pop-list will only list the datasources
that provide Xephr services.
If Simple Query was selected, in the Table pop-list, select the database table/view on which to base the block.
If Xephr Service was selected, in the Table pop-list, select the Xephr Service method on which to base the block. Choices are determined by the datasource selected.
Click on the Next button in the bottom right of the screen to continue.
The information displayed next is dependent on the setting of the Query Type property.
A list of the columns in the selected table will be displayed.
Set the Key Required flag to the desired setting. This flag defaults to on, which indicates that at least one column that is selected must have the Key flag set to on. The Next button cannot be pressed until the key column is selected or this flag is set to off.
For each column, indicate whether
the column is a primary key for the view by setting the Key flag to on or off.
To set the Key flag for all displayed columns, left-click once on the
gray Key column header.
For each column, indicate whether
the column will be included as a field on this block by setting the Field
flag to on or off.
To set the Field flag for all displayed columns, left-click once on
the gray Field column header.
In the Filters property, enter
the filters used to restrict the information returned by the select statement
for the block, if appropriate. This is also referred
to as the where clause. The statement begins with
the word WHERE.
Format: WHERE column (comparison)
value AND column (comparison)
value
For example: WHERE qty_on_hand > 0 AND stock_um in ('FT','IN')
In the Ordering and Grouping property,
enter any code to be executed after the filters, such as the order by
or group by.
Format: ORDER BY column, column,
column
Format: GROUP BY column, column,
column
For example: ORDER BY description, stock_um, qty_on_hand desc
Press the Next button at the bottom of the screen.
The next step is to set up the order of the columns for the block. Using the Move Up and Move Down buttons, arrange the columns to be in the order that you wish them to be for the conversion.
Press the Next button at the bottom right of the screen to continue.
The next step is to create additional
joins if there are multiple blocks on the converter. If
you wish to create joins, set the Create Join flag to on.
Additional properties will be displayed to allow you to define the
joining column.
In the From Column property, select the column on the child block that
will be joined to the parent block.
In the To Block property, select the block that contains the column
to which the from column will be joined.
In the To Column property, select the column to which you are joining
the from column.
The join will be added to the block when the block is created. Joins
are created as equal joins automatically.
For more information on joins, see the Joining
Data on Blocks section.
Click on the Next button at the bottom right of the screen to continue.
At this point a new screen is displayed. If you wish to add another block, set the Add Block or Labels flag to on and press the Next button.
A new screen will be displayed to allow you to select whether you want to add another block to an existing block or the entity. Click on the desired object and press the Add Block button to continue to add blocks as described above.
The screen also allows you to add labels to a block. Click on the desired block and press the Add Labels button. The Adding New Labels screen will be displayed.
To add a new label, click on the Add button.
In the field that appears under the Fields section, enter the name of the Label and press the Enter key on your keyboard.
Repeat until you have entered all desired labels.
To delete a label that you have created, click on the desired label and press the Delete button.
When all desired labels have been entered, click on the Next button on the bottom right of the screen.
The labels will be added to the block.
Otherwise, press the Finish button in the bottom right of the screen.
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.
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 filters used to restrict the information returned by the select statement
for the block, if appropriate. This is also referred
to as the where clause. The statement begins with
the word WHERE.
Format: WHERE column (comparison)
value AND column (comparison)
value
For example: WHERE qty_on_hand > 0 AND stock_um in ('FT','IN')
In the Ordering and Grouping property,
enter any code to be executed after the filters, such as the order by
or group by.
Format: ORDER BY column, column,
column
Format: GROUP BY column, column,
column
For example: ORDER BY description, stock_um, qty_on_hand desc
Click on the Next button in the bottom right of the screen to continue.
A list of the columns in the selected table will be displayed.
Set the Key Required flag to the desired setting. This flag defaults to on, which indicates that at least one column that is selected must have the Key flag set to on. The Next button cannot be pressed until the key column is selected or this flag is set to off.
For each column, indicate whether
the column is a primary key for the view by setting the Key flag to on or off.
To set the Key flag for all displayed columns, left-click once on the
gray Key column header.
For each column, indicate whether
the column will be included as a field on this block by setting the Field
flag to on or off.
To set the Field flag for all displayed columns, left-click once on
the gray Field column header.
Press the Next button at the bottom of the screen.
The next step is to set up the order of the columns for the block. Using the Move Up and Move Down buttons, arrange the columns to be in the order that you wish them to be for the conversion.
Press the Next button at the bottom right of the screen to continue.
The next step is to create additional
joins if there are multiple blocks on the converter. If
you wish to create joins, set the Create Join flag to on.
Additional properties will be displayed to allow you to define the
joining column.
In the From Column property, select the column on the child block that
will be joined to the parent block.
In the To Block property, select the block that contains the column
to which the from column will be joined.
In the To Column property, select the column to which you are joining
the from column.
The join will be added to the block when the block is created. Joins
are created as equal joins automatically.
For more information on joins, see the Joining
Data on Blocks section.
Click on the Next button at the bottom right of the screen to continue.
At this point a new screen is displayed. If you wish to add another block, set the Add Block or Labels flag to on and press the Next button.
A new screen will be displayed to allow you to select whether you want to add another block to an existing block or the entity. Click on the desired object and press the Add Block button to continue to add blocks as described above.
The screen also allows you to add labels to a block. The screen also allows you to add labels to a block. Click on the desired block and press the Add Labels button. The Adding New Labels screen will be displayed.
To add a new label, click on the Add button.
In the field that appears under the Fields section, enter the name of the Label and press the Enter key on your keyboard.
Repeat until you have entered all desired labels.
To delete a label that you have created, click on the desired label and press the Delete button.
When all desired labels have been entered, click on the Next button on the bottom right of the screen.
The labels will be added to the block.
Otherwise, press the Finish button in the bottom right of the screen.
A list of the columns for the selected Xephr method will be displayed.
For each column, indicate whether
the column is a primary key for the view by setting the Key flag to on or off.
To set the Key flag for all displayed columns, left-click once on the
gray Key column header.
For each column, indicate whether
the column will be included as a field on this block by setting the Field
flag to on or off.
To set the Field flag for all displayed columns, left-click once on
the gray Field column header.
Press the Next button at the bottom of the screen.
The next step is to set up the order of the columns for the block. Using the Move Up and Move Down buttons, arrange the columns to be in the order that you wish them to be for the conversion.
Press the Next button at the bottom right of the screen to continue.
The next step is to create additional
joins if there are multiple blocks on the converter. If
you wish to create joins, set the Create Join flag to on.
Additional properties will be displayed to allow you to define the
joining column.
In the From Column property, select the column on the child block that
will be joined to the parent block.
In the To Block property, select the block that contains the column
to which the from column will be joined.
In the To Column property, select the column to which you are joining
the from column.
The join will be added to the block when the block is created. Joins
are created as equal joins automatically.
For more information on joins, see the Joining
Data on Blocks section.
Click on the Next button at the bottom right of the screen to continue.
At this point a new screen is displayed. If you wish to add another block, set the Add Block or Labels flag to on and press the Next button.
A new screen will be displayed to allow you to select whether you want to add another block to an existing block or the entity. Click on the desired object and press the Add Block button to continue to add blocks as described above.
The screen also allows you to add labels to a block. Click on the desired block and press the Add Labels button. The Adding New Labels screen will be displayed.
To add a new label, click on the Add button.
In the field that appears under the Fields section, enter the name of the Label and press the Enter key on your keyboard.
Repeat until you have entered all desired labels.
To delete a label that you have created, click on the desired label and press the Delete button.
When all desired labels have been entered, click on the Next button on the bottom right of the screen.
The labels will be added to the block.
Otherwise, press the Finish button in the bottom right of the screen.
A list of the columns in the selected published entity will be displayed.
For each column, indicate whether
the column is a primary key for the entity by setting the Key flag to
on or off.
To set the Key flag for all displayed columns, left-click once on the
gray Key column header.
For each column, indicate whether
the column will be included as a field on this block by setting the Field
flag to on or off.
To set the Field flag for all displayed columns, left-click once on
the gray Field column header.
For each column, in the Format
pop-list, select the format mask for this field
from the list of pre-defined format masks.
Date fields must have a format mask entered. Format
masks can only be applied to date and numeric fields.
For more information, see the Format
Masks section.
Press the Next button at the bottom of the screen.
The next step is to set up the order of the columns for the block. Using the Move Up and Move Down buttons, arrange the columns to be in the order that you wish them to be for the conversion.
Press the Next button at the bottom right of the screen to continue.
At this point a new screen is displayed. If you wish to add another block, set the Add Block or Labels flag to on and press the Next button.
A new screen will be displayed to allow you to select whether you want to add another block to an existing block or the entity. Click on the desired object and press the Add Block button to continue to add blocks as described above.
The screen also allows you to add labels to a block. Click on the desired block and press the Add Labels button. The Adding New Labels screen will be displayed.
To add a new label, click on the Add button.
In the field that appears under the Fields section, enter the name of the Label and press the Enter key on your keyboard.
Repeat until you have entered all desired labels.
To delete a label that you have created, click on the desired label and press the Delete button.
When all desired labels have been entered, click on the Next button on the bottom right of the screen.
The labels will be added to the block.
Otherwise, press the Finish button in the bottom right of the screen.
Xephr is a registered trademark of NDS Systems, LC.
Copyright