At 03:17 PM 01-01-01 -0300, Mauricio Longo wrote:

>Helen,
>
>My SQL statement is quite simple:
>
>Select * from registry where Parent = :ParentId;
>
>I'm selecting all records that have the same "parent" in a table with a
>self join.
>
>I did indicate that the parameter was an Integer, both, when I was using
>the numeric(18,0) definition and later when I changed to integer.

Mauricio,
Did you solve this?

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?

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

Helen


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