case/4/0 Web Publishing: C:\Documents and Settings\hajsman\Dokumenty\Vyuka\Irs2\Projekt case40\Projekt03.csf - Vyhodnocovací funkce Entity_attribute_with_different_data_element_max(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
Entity_attribute_with_different_data_element_max
(Review-Manager Data model checks)

Vytvořeno:	02-07-2000 11:22:12
Poslední změna:	12-10-2002 11:00:16

Outputs for an attribute in the ER-Model all assigned attributes in the relational model that have different data element.

Modul

Module: Review-Manager Data model checks

Zdrojový kód:

PROCEDURE Entity_attribute_with_different_data_element_max()
BEGIN

    PRINT "Vazby atributů", NL;

    FOREACH Attribute ORDER BY Entity, Position DO

        diffFound! = FALSE;

        FOREACH Attributeconnection AS ACO WHERE ACO.Entity = Attribute.Entity AND
                                                 ACO.Attribute = Attribute.Name DO

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

                diffFound! = TRUE;

            END // FOR Relattribute

            IF diffFound! THEN
                BREAK;
            END // IF

        END // FOREACH Attributeconnection AS ACO

        IF diffFound! THEN

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

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

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

                END // FOR Relattribute

            END // FOREACH Attributeconnection AS ACO

        END // IF

    END // FOREACH Attribute

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\75901297.htm	(C) microTOOL GmbH 2002