>Can someone tell me why the following Buffering problem is occurring. In my forms DE I have set the BufferModeOverride=2 (Pessimistic Row Buffering) for the used cursor. If I APPEND BLANK and then issue a TABLEREVERT() the record doesn't go away.
>
>However, if I open the database from the command window and in its properties I Enable data buffering with Lock records set to When edited and Buffer set to Current record and then issue an APPEND BLANK and TABLEREVERT(), the APPENDED record goes away. Aren't these 2 situations the same and why doesn't TABLEREVERT() in my form seem to work properly.
>
>Thanx
if (in your form) you have moved to a different record in the table before issuing the tablerevert(), the tablerevert won't recognize that you want to delete the record -- it will only revert any changes you've made since the record was 'saved'. when you move from record to record, you are implicitly saving the changes.