Skip to main content

Uniface 10 Enterprise Edition: U10 allows relationship of an entity with itself

  • November 19, 2018
  • 2 replies
  • 0 views
Jan Cees Boogaard

U10 allows relationship of an entity with itself

Author: ulrichmerkel@web.de (ulrich-merkel)

When I want to create a relationship in U9 where one and many are the same entity, an error is raised; I have to use a subentity. The same situation in U10 is accepted. This will cause a lot of problems in frame-into-frame etc. <OCC> <DAT name="U_GLAB">EMPLOYEES</DAT> <DAT name="U_VLAB">NORTHWIND_SQLITE</DAT> <DAT name="U_RGLAB">EMPLOYEES</DAT> <DAT name="U_RVLAB">NORTHWIND_SQLITE</DAT> <DAT name="UKVERSION">2</DAT> <DAT name="UMVERSION">1</DAT> <DAT name="UDESCR" xml:space='preserve'>EMPLOYEES.NORTHWIND_SQLITE =&gt; EMPLOYEES.NORTHWIND_SQLITE</DAT> <DAT name="U_DELC">NUL</DAT> <DAT name="U_KSEQ">1</DAT> <DAT name="U_FIDX">F</DAT> <DAT name="U_INTEGRITY">F</DAT> <DAT name="U_FLABS">REPORTSTO</DAT> </OCC>

2 replies

Jan Cees Boogaard

U10 allows relationship of an entity with itself

Author: ulrichmerkel@web.de (ulrich-merkel)

When I want to create a relationship in U9 where one and many are the same entity, an error is raised; I have to use a subentity. The same situation in U10 is accepted. This will cause a lot of problems in frame-into-frame etc. <OCC> <DAT name="U_GLAB">EMPLOYEES</DAT> <DAT name="U_VLAB">NORTHWIND_SQLITE</DAT> <DAT name="U_RGLAB">EMPLOYEES</DAT> <DAT name="U_RVLAB">NORTHWIND_SQLITE</DAT> <DAT name="UKVERSION">2</DAT> <DAT name="UMVERSION">1</DAT> <DAT name="UDESCR" xml:space='preserve'>EMPLOYEES.NORTHWIND_SQLITE =&gt; EMPLOYEES.NORTHWIND_SQLITE</DAT> <DAT name="U_DELC">NUL</DAT> <DAT name="U_KSEQ">1</DAT> <DAT name="U_FIDX">F</DAT> <DAT name="U_INTEGRITY">F</DAT> <DAT name="U_FLABS">REPORTSTO</DAT> </OCC>

Yes, that is wrong. It should not be possible to model a relationship between an entity and itself without using a subtype: the many entity at hand should not appear in the Model tab of the Resource Browser on the Entity Editor's Define Relationships worksheet Fortunately, UF10 does not allow you to create a Component Data structure that contains the same entity twice, so there are no frame-inside-frame issues (some real old Uniface speak here ;-)


Author: Henk van der Veer (henk.van.der.veer@uniface.com)
Jan Cees Boogaard

U10 allows relationship of an entity with itself

Author: ulrichmerkel@web.de (ulrich-merkel)

When I want to create a relationship in U9 where one and many are the same entity, an error is raised; I have to use a subentity. The same situation in U10 is accepted. This will cause a lot of problems in frame-into-frame etc. <OCC> <DAT name="U_GLAB">EMPLOYEES</DAT> <DAT name="U_VLAB">NORTHWIND_SQLITE</DAT> <DAT name="U_RGLAB">EMPLOYEES</DAT> <DAT name="U_RVLAB">NORTHWIND_SQLITE</DAT> <DAT name="UKVERSION">2</DAT> <DAT name="UMVERSION">1</DAT> <DAT name="UDESCR" xml:space='preserve'>EMPLOYEES.NORTHWIND_SQLITE =&gt; EMPLOYEES.NORTHWIND_SQLITE</DAT> <DAT name="U_DELC">NUL</DAT> <DAT name="U_KSEQ">1</DAT> <DAT name="U_FIDX">F</DAT> <DAT name="U_INTEGRITY">F</DAT> <DAT name="U_FLABS">REPORTSTO</DAT> </OCC>

... it's still a frame-in-frame issue because one can not display data from the "one" together with data from the "many" in one form.


Author: ulrich-merkel (ulrichmerkel@web.de)

Recent badge winners

Explore all badges
Terms & ConditionsAccessibility statement