At 12:25 PM 31-01-01 +0100, you wrote:

>Hi list,
>
>I have a table with the following methadata:
>
>create table testtable
>(id int4 primary key,
> nr char (5) not null,
> kurz char (15),
> name char (30),
> ref_id int4);
>
>create index testtable_nr on testtable (nr);
>create index testtable_kurz on testtable (kurz);
>create index testtable_name on testtable (name);
>
>alter table testtable
>add constraint testtable_ref_id foreign key (ref_id)
>references testtable id);
>
>ref_id could contain the id of annother record of the same table or
>null.
>
>in a ib_query I have the following settings:
>
>sql:
>select table1.id, table1.nr, table1.kurz, table1.name,
>table2.nr as ref_nr
>from testtable table1
> left outer join testtable table2 on (table2._id = table1.ref_id)
>
>orderingitems:
>nr=table1.nr; table1.nr desc
>kurz=table1.kurz
>name=table1.name
>
>orderinglinks
>nr=1
>kurz=2
>name=3
>
>When I set the query to active, it works normaly.
>When I place an ib_grid on a form and connect the grid to the ib_query
>by an ib_datasource, it works normaly as long as I set the
>orderingitemno to 1. Then I get the errormessage: problem in
>bindingcursor
>
>Every time, I change the orderingitemno by clicking on the related
>column I get this errormessage.
>What is the reason for this?

This is a self-referencing table and the left outer self-join is based on a
nullable link column. Therefore you are getting null outputs in all your
orderingitems columns wherever a parent has no children. Get the output
instead via a selectable stored procedure that returns emptystrings or
zeroes (as applicable) in these null columns.

Helen



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