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