I've seen this error before. In my case, the parameter passed to the view was the incorrect type (a logical value instead of a numeric) and the view reported this error during requery.


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