case/4/0 Web Publishing: C:\Documents and Settings\hajsman\Dokumenty\Vyuka\Irs2\Projekt case40\Projekt03.csf - Vyhodnocovací funkce Relation_attributes_with_different_data_element(modul: Review-Manager Data model checks)

[Celkový datový model] [Funkce] [Externí rohraní] [Stavové diagramy] [Datové elementy] [Entity] [Relace]
[Databáze] [Události] [Materiály] [Generovací funkce] [Vyhodnocovací funkce] [Konfigurace] [Uživatelé] [Projekt] [Home]

Vyhodnocovací funkce
Relation_attributes_with_different_data_element
(Review-Manager Data model checks)

Vytvořeno:	01-28-2000 12:08:22
Poslední změna:	12-10-2002 11:06:11

Outputs for an attribute in the relational model, all assigned attributes in the ER-Model with different data element, if all assigned attributes are concerned.

Modul

Module: Review-Manager Data model checks

Zdrojový kód:

PROCEDURE Relation_attributes_with_different_data_element()
BEGIN

    PRINT "Vazby atributů", NL;

    FOREACH Relattribute ORDER BY Relation, Position DO

        sameFound! = FALSE;

        FOREACH Attributeconnection AS ACO WHERE ACO.Relation = Relattribute.Relation AND
                                                 ACO.Relattribute = Relattribute.Name DO

            FOR Attribute WHERE Attribute.Entity = ACO.Entity AND
                                Attribute.Name = ACO.Attribute AND
                                Attribute.Data = Relattribute.Data DO

                sameFound! = TRUE;

            END // FOR Attribute

            IF sameFound! THEN
                BREAK;
            END // IF

        END // FOREACH Attributeconnection AS ACO

        IF NOT sameFound! THEN

            FOREACH Attributeconnection AS ACO WHERE ACO.Relation = Relattribute.Relation AND
                                                     ACO.Relattribute = Relattribute.Name
                                               ORDER BY Entity, Attribute DO

                FOR Attribute WHERE Attribute.Entity = ACO.Entity AND
                                    Attribute.Name = ACO.Attribute AND
                                    Attribute.Data <> Relattribute.Data DO

                    CALL Util_PrintAttributeconnection(ACO.Tid, "r");

                END // FOR Attribute

            END // FOREACH Attributeconnection AS ACO

        END // IF

    END // FOREACH Relattribute

END

Generováno: 16.10.2003 7:41	Systém: C:\Documents and Settings\hajsman\Dokumenty\Vyuka\Irs2\Projekt case40\Projekt03.csf	Generováno systémem case/4/0
Vygeneroval: Administrator	Soubor: C:\Documents and Settings\hajsman\Dokumenty\Vyuka\Irs2\Projekt case40\html\582737720.htm	(C) microTOOL GmbH 2002