Subject Recursive Problem !!
Author Agung Wibudi
Hi All,
I 've problems with sorting data that implement with stored procedure.
The Store procedure is Recursive's stored procedure.
Structure data in table like :

field1 ID CHAR(2),
field2 Parent_id char(2) (Child of field1),
field3 Level integer (The level Of record , 1 is parent, 2 is child, etc)

I want to sort that table like parent child method.

I always failed to get the results (returns in SP always NULL use Suspend).

How to get the output of the child record ;


[Non-text portions of this message have been removed]