Helen,

>Mauricio,
>Did you solve this?

Not yet. However, with all the confusion around the New Year's celebration I
never got to test it under the latest release of IBO. I'm going to do it
tomorrow. :-)

>It's probably a matter of terminology, but this statement isn't a
>self-join...I assume you mean that the table is self-referencing?

Yeah, that's what I meant. Sorry...

>How are you passing the :ParentID parameter to the statement? Perhaps
>picking it up from another dataset over the same table?

No. Actualy, I getting it from something like: .... :=
StrToInt(Edit1.Text);

The value of the edit component's text property was set by a conversion to
string of the Id of the "root" element of my table which was selected
through a statement like:

Select * from registry where parent is null;

Since I have a trigger that keeps me from having more than one record with a
null parent I can get the first record of the result set certain that it's
the one I want. :-)

Best regards,

Mauricio Longo

>Helen


>All for Open and Open for All
>InterBase Developer Initiative · http://www.interbase2000.org