lcFieldState1 = GETFLDSTATE(-1,"MyView") && returns 111211 llSuccess = TABLEUPDATE(.F.,.T.,"MyView",laError) && returns .T. lcFieldState2 = GETFLDSTATE(-1,"MyView") && returns 111211 * IF NOT llSuccess *-- llSuccess = .T. so this does not fire. =AERROR(laError) =MESSAGEBOX(laError[2]) ENDIF * =REQUERY("MyView") && Error: Update conflict in cursor 'MyView'This turns out to be a very difficult thing to solve.
=TABLEUPDATE(.F.,.T.,"MyView") >>>=REQUERY("MyView")>>>If the result of the requery would be an empty view, which may happen, I receive at line 2 the following error message:
Update conflict in cursor 'MyView'>>>The help suggests to use TABLEUPDATE(), this is why I put in the first line, but it does not change the behavior.