>For some (important) reasons, I have defined a following buffering schema
>in my form's dataenviroment:
>
> [Local table] (table optimistic-5) - items of an invoice (invisible for a
>user).
> . Table buffer allows to implement 'Cancel/Save Changes'.
> /|\
> | automatically updated by view
> |
>
> [Local view - editable] (row optimictic-3) - a certain subset of mentioned
>items,
> . all form's controls bound to it.
> / \-----
> / \
> / \--- Some local, read only views for presenting data.
> |
> |--------
>
>The problem:
>1.I have set double buffer: row for a view and table for a local table.
>When I add a record to a view, it has '3' or '4' field states in a view's
>buffer. After '=tableUpdate' it changes to '1' field states and a record
>appears in a table buffer (by automatic update) with '3' & '4' states.
>2. From this point every attempt to '=tableupdate' is unsuccessful with
>error 1585-update conflict.
>
>Question: How can I force VFP to accept changes in new records?
>
>Any suggestions appreciated.


TABLEUPDATE() has a Forced save option.

TABLEUPDATE([nRows [, lForce]] [, cTableAlias | nWorkArea]

By setting lForce to TRUE you can force an update.

HTH,
Tom