The ugly workaround is to make 'Desc' non-updatable in View, and change data directly in table from appropriate textbox.InteractiveChange or from cmdSave.click (depending on interface functionality).
>Thanks, but my issue is that the field has been around for 5/6 years, and renaming the field would be undesirable at this point. I would much rather have a work-around.
>
>Things I've tried:
>* changing the view to use an "AS cDesc" clause
>* changing the "update" settings on the update tab
>
>Nothing has worked so far.
>
>Bob
>
>>Look at the online help at 'Reserved Words'. These should
>>not be used as field or variable names.
>>-myron kirby-
>>=========================
>>>We have an old table that has a field named "desc" that worked perfectly. Now we have found that TABLEUPDATE() fails when we have a view that includes this field.
>>>
>>>How can we get the TABLEUPDATE to succeed without renaming our field?
>>>
>>>
>>>Bob
Edward Pikman
Independent Consultant