>>Yes: 10, Syntax error. No error unless that one field's value changes in the view.
>
>What is the name of the field it is changing? What is the value it is trying to set it to?
>
>An updatable view is simply a wrapper to basic SQL. When you update the values and issue a Tableupdate, the engine goes through and based on the update settings of the view, builds an UPDATE SQL statement to handle the actual update.
>
>If the name of the field is a reserved word, you may have problems. This is normally the case when using remote views. If there are embedded character delimeters, you may get an error.

I tested the update outside the application using just the database and view. What happens is that even when browsing the view, if I change a value in the problem field, it generates a syntax error. Once the error is generated, I can not move from that row and column with getting the error again. If I start out by changing the value of a diffent field, everything is fine. Only that field causes the problem.