Macro Toolbox › Relationship Macros › %NotnullFK()

%NotnullFK()

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.