Helen,

Thanks. It worked out fine when I set the RequestLiveDataset property
and the Edit/Insert/Delete SQL statements.

Remco.

--- In IBObjects@y..., "Helen Borrie (TeamIBO)" <helebor@d...> wrote:
> At 08:34 AM 28-01-02 +0000, Remco Kortekaas wrote:
> >Hi,
> >
> >Can anyone give me a hint in what situations it is that the edit
and
> >delete buttons on de ib_update bar stay grayed out? The insert,
> >commit and rollback buttons on their turn are not grayed out, the
> >dataset is not read-only. On another dataset all works well.
>
> Is this a joined dataset? If so, you will need to set KeyRelation
to be the table upon which you want edits and deletes performed (in
this case I'm bemused by why the insert button is not greyed out..)
or to set explicit statements in EditSQL, InsertSQL and DeleteSQL
properties.
>
> If it's not a joined dataset then the reason is that your Keylinks
are either wrong (don't correspond to the primary key of the
underlying table) or they are missing. Otherwise, there is no way to
determine which row is to be updated or deleted - and the update bar
reflects this. (It can insert OK without Keylinks but you will
probably have trouble finding the inserted records after a refresh...)
>
>
> Helen Borrie (TeamIBO Support)
>
> ** Please don't email your support questions privately **
> Ask on the list and everyone benefits
> Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com