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?

Regards
Helmut