Compares the foreign key of a child table in a relationship to <null expression>. This macro expands if and only if the relationship is non-identifying, nulls allowed.
Syntax
%NotnullFK(<child table>, <not null expression>)
Syntax Example
%NotnullFK(%Child,"is not null and")
Expansion
MOVIE_RENTAL_RECOR.master_number is not null and
MOVIE_RENTAL_RECOR.movie_copy_number is not null and…
Full Syntax
%NotnullFK(<child table>, <not null expression>,<prefix>,<separator>)
Full Syntax Example
%NotnullFK(:%New,"is null","where"," or")
Expansion
Where
:new.master_number is null or
:new-movie_copy_number is null
Usage
Classified as a Relationship macro that can used in RI Override, Rel Override, %ForEachParentRel, %ForEachChildRel.
|
Copyright © 2013 CA.
All rights reserved.
|
|