>I am creating a CursorAdapter based on a tablename the front-end passes me. I create the select cmd, set .AllowUpdates and .AllowDeletes to .t. and send the object back to the front-end.
>
>If the user wants to change the table name the CA is using to base the view filters on and seee new data, the front-end is setting the adapter object to null and then calling the function to build the adapter with the new table name. The problem is the changes are getting saved to the underlying tables without a TableUpdate() or any save code being run. I had the front-end coder change the .AllowUpdates and .AllowDeletes to .f. and try it and it still saves changes without any save type call.
>
>Any idea on why? I do not have to set buffering on do I? The help doesn't discuss this aspect.

Dwfault Buffering mode of the CA is optimistic row buffering, so if you move the record pinter all changes is saved. Change it to Table buffreing.