Products Downloads


French version


 

 

 

Assignment

Logical entities.

 

 

Use

Generation of instructions before the 4GL instructions deleting the logical entities in the database (DELETE_ON_KEY, DELETE, SUPPRESSION_L1, SUPPRESSION_L2), when the program is generated using the implicit management rule generation option.

 

The "delete" event and the "before" trigger point will be incorporated into the trigger modules (Adelia/400's RPG generator).

 

 

Substitution principles

  • The management rule text variables $$Id are replaced by the name of the view concerned by the database file access instruction or by the name of the logical entity concerned by the database SQL access instruction.

  • The management rule text variables $LogicalProperty are replaced by the guide word associated with the property named LogicalProperty, if the latter belongs to the entity to which the management rule is assigned.

 

Example

Deleting an order resulting in the deletion of order lines.


1. Specification of the management rule:

DEFINE_VIEW ORDER_LINES ORDLIN KEY ;$ORDER_NUMBER

DELETE_ON_KEY ORDER_LINES

 

2. Result in the program:

DELETE_ON_KEY ORDER_LINES

 

Note: The ORDER_LINES view will be defined with the CC_ORDER_LINES field as key.

 

↑ Top of page

  • Aucune étiquette