Yes of course. I could edit and update other fields in the view except this particular field. Very strange.
>This is probably a silly question, but is the view marked as updateable and is the field in question updateable?
>
>>Whenever I try to change a value in one of the fields in the view, I get a "Syntax error". I could browse the table and make changes to this field w/o any problem (it's just a free standing character field) but get this error when trying to change the value from a view based on this same table. The view doesn't use any other table but this one table (no joins) and has one parameter in the WHERE clause to pull-in just the subset. The recs selected by view is OK but I just can't edit anything on this one field! Very strange.
>>
>>Anyone experienced this kind of problems before with views?
It's "my" world. You're just living in it.