>>>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.
>
>Hmmmm... I thought it might be the first one (it was called DESC), but that wasn't it as I changed the name throughout and it still failed. The second one though... This is a description field and contains a variety of freeform text - are you asking if the field value itself contains some characters that might cause problems in the update?
*snip*

What I have done in the past is check for the existence of the following before saving:

[ " '

If one existed, I told the user the value was invalid and they had to change it. You can do that or use chrtran() to get rid of the problem characters entirely.