The INSERT worked just fine. Any reason why this is so?
>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