>
>Ken,
>How many tables are involved in your view?
>May be you have more then one tables and you set some fields from other tables to be updatatble, but not have KeyField(s) defined for that/these table(s).

Hi Borislav,

There are two tables in this view but only one is updated. The keyfield for the updatable table is marked in the view designer and SQL updates is checked. No fields in the other table are marked for update.

Thing is this behavior has only occured twice, and I have been able to fix it by simply opening up the view in the designer and saving it again.

I imagined it was some kind of corruption to the DBC but neither cleaning up the DBC or validating it fixed the problem.

I was hoping there was some reason for this or at least a way I could automate a fix.

Ken