>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.
lcFieldState1 = GETFLDSTATE(-1,"MyView") && returns 111211 ? "Check ",CURSORGETPROP("BatchUpdateCount","MyView")=1 llSuccess = TABLEUPDATE(2,.T.,"MyView","laError") && returns .T. lcFieldState2 = GETFLDSTATE(-1,"MyView") && returns 111211