>>>I just ran into an odd problem. I have a form with the BufferMode set to Optimistic. I have a view that I use in this form. If I pull a record from the view and make changes to that record, the changes should not be commited until I do a TableUpdate, no? For some reason the changes are being commited without me ever issuing a TableUpdate.
>>
>>In a case of Row Buffering, updates go back automatically when you move pointer off the record.
>
>Correct me if I am wrong, it seems that if you are on row buffering, moving away will update the view but not the underlying tables. The underlying tables will only get updated on tableupdate. True or false?
False, view is just temporary storage to automate updating of underlying tables, i.e. from data standpoint the only thing you 'update' is table(s). Row buffering assumes automatic table record update when pointer is moved off the record.
Edward Pikman
Independent Consultant