IIf (testExpr, expr1, expr2) |
If testExpr is TRUE, returns expr1's value, otherwise returns expr2's value. IfNull is the return type of its first argument even if the first argument is NULL. The second argument is converted to the type of the first argument before its value is returned. For example: IIf ([Last Name] IS NULL, "foo", "boo")
returns foo if [Last Name] is NULL. |
BCHasRows (BO, BC, search_expr, visibility) |
Returns TRUE if the business component BC that is a part of business object BO has any rows after applying the search_expr and visibility. Evaluates to TRUE or FALSE depending on whether a given business component would return any records given the search specification and visibility. For example: BCHasRows ("Contact", "Contact", "", "Organization")
returns TRUE if there are 1 or more rows of contacts. For example, you could hide an applet based on how many records it displayed. However, hiding and showing detail applets using BCHasRows is not possible. |