Wednesday, May 11, 2022

Tip of the Day: New Rule Notification for Dropped Columns
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.4.20421 or higher
Sections......: Data Designer
Keywords......: Rule, Column, Table, Warning

Did you know that a notification will now appear after a column is dropped from a table, where a rule is defined for that column?

After dropping a column, the rules are now checked. If a rule for the table becomes invalid, an error message about the now dropped column will be displayed, similar to the message when a table/view is dropped and a view is dependent on that dropped table/view.

A rule is a condition placed upon a column, which R:BASE checks during data entry to ensure that the data meets specific criteria.

Rules can be created with predefined options, or with custom rules. Rules can be set to work with data entry and data deletion. A data entry rule ensures that the data entered into a column meets the criteria you specify. A data deletion rule ensures that data deleted in a column also meets specified criteria.

When you enter/edit or delete data, R:BASE checks the data with the corresponding rules. If the conditions of a particular rule are not met, R:BASE displays the error message defined for that rule. Rules can even be set to fail to meet conditions, and otherwise, R:BASE displays the error message defined for that rule.

Rules may be turned ON and OFF on demand with the RULES setting.

Syntax.: SET RULES ON/OFF
Default: ON

SET RULES determines whether R:BASE checks data against all existing rules during data entry and modification when you use the EDIT, EDIT USING, ENTER, INSERT, LOAD, or UPDATE commands, or the import/export utility.

Very Best R:egards,

Razzak.

R:BASE Technologies, Inc.
https://www.rbase.com


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1Mc0dX-1oLtQl1V0R-00dURX%40mrelay.perfora.net.

Reply via email to