There is no validation or triggers against the base table. The view previously worked fine.
I can make changes to the base table with no problems.
I have also re-created the local view.
If you change the contents of one field, and try to issue tableupdate it generates the syntax error. If you save with no changes made, you do not get the error.
>>
>May be there is an error in any validation or trigger code related to the basic table of the view - if there exist any code this code is fired during TableUpdate().
>Try the same kind of data changing directly to the related table - may be that helps to find out what's going wrong!