Sorry then,
I don't know what could cause this error. But why you not switch to CursorAdapter(s) instead of View. That was my first job when i jump to VFP 8 from VFP6. Much easier to manage. More flexible then views and doesn't have this hateful builder :o)


>>
>>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