Access
To display, create or modify the record selections-omissions on a join entity, select the SEL/OM option in the context-sensitive menu (or the equivalent button) in the Join entities tab of the LDM/PDM screen.
Displayed data
Name and description of the processed join entity.
Lists
Select-Omit
List of select-omit expressions of the access.
The item sequence in the list can be modified.
Single-selection list.
S/O (selections/omissions)
Operation to be applied to the property.
Values available:
S |
Selection of records. |
O |
Omission of records. |
" " |
Complement of selection or omission operation. |
Property
Name of the property to which the selection or the omission is applied.
This field is associated with the use of the "COMPARE", "RANGE" and "VALUE" functions.
Function
Function type.
Values available:
ALL. |
COMP (COMPARE.) |
RANGE. |
VALUE. |
Oper. (operator)
Comparison operator, associated with the "COMPARE" function.
Values available:
= |
EQ |
EQUAL |
<> |
NE |
NOT_EQUAL |
< |
LT |
LESS_THAN |
!< |
NL |
NOT_LESS_THAN |
> |
GT |
GREATER_THAN |
!> |
NG |
NOT_GREATER_THAN |
<= |
LE |
LESS_THAN_OR_EQUAL |
>= |
GE |
GREATER_THAN_OR_EQUAL |
Data entry
Value(s)
Value of the properties associated with the selected function.
Syntax:
C function |
A value. |
R function |
A minimum limit and a maximum limit separated by a space. |
V function |
A list of values separated by spaces. |
A function |
No value to specify. |
The values can be constants or properties of the access's specific format.
Alphanumeric constants must be entered between single quotes.
Buttons
Add
This button adds to the selection-omission list a selection or omission expression defined in the input fields.
Modify
This button replaces the expression selected in the list with the values defined in the input fields.
Delete
This button deletes the selected expression from the list.
Modify (validation)
This button validates the modifications made and closes the dialog box.
Cancel
This button closes the dialog box without validating the modifications made.
Keyboard shortcut: Esc.