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>


  1. 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)
  2. ... 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)