>While using a local view on a table that has a memo field (comments), the memo field does not get updated when =TABLEUPDATE() is applied.
>
>In the local view, sql updates is checked and so is the memo field to be updated.
>
>The local view has Optimistic Table Buffering on while the table has Pessimistic.
>
>For example:
>
>Begin Transaction
>Select local_view
>llOk=Tableupdate(1,.T.)
>If llOk
> End Transaction
>Else
> Rollback
>Endif
>
>Does anyone know if there is a work around for this ???
>
This sounds like the exact problem the Sybase people here are having with their Text type (which is like memo). Since a Memo/View Tableupdate works fine by itself, it looks like the Transaction here is the problem. Maybe someone else knows more about this, but as I say, sybase has the same Transaction problem so it may be a "design" bug...