Re: Nearest Common Ancestor Report (XDb1's $1000 Challenge)

> > XDb1's data/schema does allow each thing to have 0 to many
> > names while the provided solution's data/schema does not.
>
> Yeah right.

Yes, that is correct, in XDb1 dbs, each thing can have 0 to many names. While the earlier versions do have errors in its NLI that prevent one from accomplishing as such, one could have used the GUI or API.  
> 'john's name is johnnyboy.'

Older versions of XDb1 didn't process this correctly. In older versions, to accomplish similar via GUI:

1. Create 'jonah' (there was also an error in processing names with duplicate symbols).

   ---

2. Select node thing/name in tree.
3. Press Ctrl+T to create an instance of name. A new instance appears with its label in edit mode.
4. Type 'jonah' and press Enter.
5. Relate the name 'jonah' as a property/value of john.

   ---

6. Select 'jonah' in the tree.
7. Click 5th ToolBar Btn (tip says 'Relate as value') or Ctrl+L.
8. Select thing/person/john.
9. Click Paste button or Ctrl+V.

Repeat above process to relate additional names to the person.

The node for the person, now displays "john jonah" instead of "john". To see each name individually as a child of the person, check "Name" in the View Menu. Reload by double-clicking him. One now sees:

Before                After
-------------------   ---------------------
thing                 thing
  person                person
    john                  john jonah
      john                  john
      35                    35
                            jonah
        

In XDb1, a name and that which it names are two separate things. With Parenthesis checked in the View Menu, the tree would appear as:

(thing)
  (person)
    (john)(jonah)

      john
      (35)
      jonah

To add a name to a thing via API, one method is:

    T_Val_relate(pJohn, pName_g, "jonah");

For additional info, see www.xdb1.com/Basic/Name.asp Received on Tue Jun 01 2004 - 23:44:11 CEST