>>>what is the difference and advantages of using the BUFFERMODEOVERRIDE in the data enviorment 'data' methods vs. the BUFFERMODE in the forms 'data' methods.
>>>
>>>if I use the BUFFERMODE in the forms data methods it has choices 'none, presimistic, optimistic' - but it does not say if this is record or table in its scope.
>>>
>>>any help out there?
>>>
>>>jim
>>The default in the forms data enironment is either optimistic or pessimistic row buffering. You can override this using either CursorSetProp() or BufferModeOverride.
>>
>>Hope this helps.
>>
>>George
>
>thanks George, it does help. what do you tend to prefer for better execution, setting the Buffermoderoverride or using the default in the forms data enviornment?
>
>thanks
>jim
Jim,
I guess it depends upon your environment in the end. I tend to override the defaults in many cases and use optimistic table buffering. I am forced to use optimistic buffering in many circumstances due to the use of remote views to Paradox. In general I prefer table buffering when feasible.

Again, as far as whether to use optimistic or pessimistic buffering will also depend upon your environment. If the chances are fairly good that users will be attempting to change the same record(s) at the same time then pessimistic might be your best choice.

Is this a little clearer or did I just muddy the waters? :)

George