|Subject||Re: Problem with KeyLinks|
> Because it has no way to target a specific row in a specific table,If I could use aliases maybe ibo could figure out the rest, or maybe
> as it can with a regular join.
if I could edit the sql used for singleton select.
> You can't use KeyRelation to make a self-referencing join queryIf I enable FetchWholeRows and disable sync after edit and post, so I
> updatable. KeyRelation absolutely requires to be able to target a
> unique row in the underlying KeyRelation member. Your flat
> structure doesn't allow this.
tell ibo not to try and run singleton select then it works, the query
is live. But I guess this is just a "side effect"/feature/"wrong
using" or whatever you want to call it.
> There are various ways you could implement an updatable structureThank you for that information. It help me better understand ibo
> out of this relationship.
internals. Method 3 is ok for me. Or I could create a view (but not
updatable as I only want to get the boss name from table person and if
the join doesn't have to tables with the same name then is ok:
create view boss (id_boss, boss_name)
as select id, name from person
and then just:
inner join boss b
on p.id_boss = b.id_boss
Thanx again for the info.