. 3. . C++Builder 3.0,  "/"  Internet
. 5.23.  ,    ,      detail-
     CASE-  ,  ,         :
-  Trigger USER2.TI_HOLDINGS
CREATE TRIGGER USER2.TI_HOLDINGS AFTER INSERT
ON USER2.HOLDINGS
FOR EACH ROW
declare numrows INTEGER;
begin
/* ERwin Builtin Sun Sep 14 18:43:47 1997 */ /* CLIENTS R/1 HOLDINGS ON CHILD INSERT RESTRICT */ select count(*) into numrows from CLIENTS where
/* %JoinFKPK(:%New,CLIENTS," = "," and") */ :new.ACCT_NBR = CLIENTS.ACCT_NBR; if (
/* %NotnullFK(:%New," is not null and") */ :new.ACCT_NBR is not null and numrows = 0
) then
raise_application_error(
-20002,
'Cannot INSERT "HOLDINGS" because "CLIENTS" does not
exist. '
); end if;
102
       /
--   ERwin  Builtin  Sun  Sep   14   18:43:47  1997
end;
,       ,            "integrity constraint"  "parent key not found".         ,       ,          ,           .  CASE- -,.,             CASE-   ,      .  ,      ,       .
 ,       ,    CASE-,         ,       ,      .
103