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
If it's not broken, fix it until it is.
My Blog