Jos,

This sounds as a keylinks problem.
How is your keylinks setted?
Also, there is a property called KeyRelation that can be used to say IBO
which table is to update. But on simple queries as you described that is not
necessary.

Luiz.

----- Original Message -----
From: "Joe Martinez" <joe@...>
To: "IB Objects" <IBObjects@yahoogroups.com>
Sent: Sunday, December 08, 2002 4:01 PM
Subject: [IBO] Why can't I delete or append my query?


> I'm using a TIB_Query. The query has a join in it to pull in another
field
> from another table. I'm using explicit left outer join syntax for the
> join. I'm using a TIB_Grid to display the data.
>
> But, if I try to call the Delete() or Append() methods on the TIB_Query, I
> get an exception, telling me that it can't append a row, or can't delete
> the row (no other details are given).
>
> If I remove the join, it works fine. What do I need to do to make this
> work with the join?
>
> -Joe