Fields
Fields can be defined for stored procedures. These are fields that are returned by any SELECT statements in the stored procedures.
At the moment fields are only supported for MSSQL and DB2 databases.
The stored procedure fields can be edited as follows:
- Select the "Fields" node in the left-hand pane as follows:
- Ensure that the stored procedure is locked by selecting the lock button in the toolbar.
- To insert a field: right-click in the right-hand pane and select "Insert".
- To delete a field: right-click on the field name and choose "Delete".
- Field properties are set via the object inspector. You can also set it via the bulk mode screen by right-clicking in the right-hand pane and choosing the option "Bulk Mode". The bulk mode screen lets you view and edit the fields in a free-format text window. See Bulk Mode for more information.
The following properties are set on the Fields screen:
|
Property: |
Description: |
Value: |
|
Name |
Name of the fields. The name must match the name of the result set column. | <Text> |
|
Type |
Field type. | <Alpha | Boolean | Financial | Integer | Numeric | Signed | String> |
|
Length |
Maximum number of characters for the field, including any decimal positions. Not applicable for
String, Integer or Boolean. |
<Integer> |
|
Decimals |
Number of decimals for the field, which is included in the Length. Not applicable for Alpha, String, Integer or Boolean. |
<Integer>
|
| Array |
Array dimensions. Up to 6 dimensions can be specified, separated by commas. |
<[Integer], [Integer], ..]> |
| Inherits from |
The name of the dictionary item from which the field properties are inherited. |
<Dictionary item name> |
|
Comments
|
Description of the field. | <Text> |
| Encrypted |
Set to "True" if the field values are stored encrypted in the runtime database. |
<True>/<False> |