>When desiging a view and have the following expression as one of the fields:
>
>
PADR(MyTable.MyMemoField,200) As MyCharacterfield
>
>it is impossible te make this field updatable within the query designer. When I manually set updatable to .T. with changing the the DBSETPROP line into
>
>
DBSetProp(ThisView+".MyCharacteField","Field","Updatable",.T.)
>
>within the SQL window, it's automatically reset when I save the View. The only workarround is to bypass the view designer and use a PRG to define the view programtically.
>
My guess would be 'by design'. You're creating a custom field, and I don't think updates from them can be saved. Include the memo field with its original name and it should update without problems.
Chris.