ERwin . (, , - ON DELETE CASCADE). ERwin, .
, , :
%Action - UPDATE/INSERT/DELETE;
%ForEachAtt(<>,<>) { < > } - ;
%ForEachEntity() { } - ;
%If, %else - . , on delete cascade:
%Action /* ERwin Builtin %Datetime */
/* %Parent %VerbPhrase %Child ON PARENT DELETE CASCADE */
delete %Child
from %Child,deleted
where
/* %%JoinFKPK(%Child,deleted," = "," and") */
%JoinFKPK(%Child,deleted," = "," and")
, positions - salary_track :
DELETE /* ERwin Builtin Fri Jun 02 17:12:09 1995 */
/* positions salary_track ON PARENT DELETE CASCADE */
delete salary_track
from salary_track, deleted
where
/* %%JoinFKPK(%Child,deleted," = "," and") */
salary_track.empl_id = deleted.empl_id
, , . , , , .
, ERwin , .
ERwin ( ) ( ) . (, PowerBuilder) .
4GL.
.10 , PowerBuilder. , , , ( - Sybase).
. 10. PowerBuilder
. , , . , "" , " " "" - .
.11.
|
|
. 11.
. , , - 4GL.
- . , "" . , , . , Sybase :
sp_addtype person_name, "char(64)", "NOT NULL"
, , , -, - , -. , . " ", ERwin. .12.
. 12.
( , ), ( ) DDE.
Logic Works - RPTwin, ERwin. RPTwin .13.
. 13. RPTwin