Assigns a value to an attribute in insert mode, and works as a filter when using the navigation buttons.
Equal(att , expression);
Is the attribute to which a value will be assigned.
Is the expression that will be assigned to the attribute (att). It can be any variable, attribute or constant, and must be the same type as that given to the attribute (att).
This rule assigns an expression to an attribute in insert mode. For Update and Delete mode the rule will be generated as att = expression condition to filter records when using the navigation buttons or receiving the transaction primary key as parameter. The Equal rule first parameter (att) will be read-only in all Transaction modes.
Considering the following Invoice Transaction:
InvoiceDate will be read-only in all transaction modes. The Equal rule will automatically assign the current date to the Invoice Date attribute when the Transaction is in Insert mode. When navigating transaction records using Navigation Buttons, only those records where "InvoiceDate = Today()" will be retrieved, skipping the records different than Today().
- When using the Update mode, the Equal rule is generated as a filter so it will never update the Equal rule first parameter (att).
- If you try to access a record that does not match the filter (by manually entering the primary key), you will get a "Record not found" message.
- The Prompt does not take Equal rule as a filter.