Either try with insert (instead of append blank and replace) or with buffering 5.

>In the Init of my form I have an SQLEXEC() which retrieves data from a MySQL table.
>CURSORGETPROP("Buffering") is 3
>
>I have an ADD RECORD button which does

>APPEND BLANK
>REPLACE cid WITH SYS(2015)

>
>I have CANCEL button which does a TABLEREVERT(.T.) which returns a 1
>
>However the APPENDED record is still there.
>
>What settings do I need so that the APPENDED record disappears from the cursor????
>
>Thanks to all
>
>...........Rich