>>You can do that visually.
>>
>>Just use the data environment and add your tables in it. Then, from each table properties, you can set the buffering.
>
>FWIW, in almost all cases I use optimistic row buffering, so in my base form classes' load method, I loop through my DE's cursors and set the buffering automatically to 3 (the DE doesn't auto open its tables), skipping ones that are set to anything other than 1 ("use form setting"). Then I open the tables. This been working really well for me--it's easier to remember to set autoopen .f. than all the cursor's buffering! It slows down my form load though...
Yes, this is what I have as well except that I go with 5. But, again it depends on each application needs. Some of them may not accept an optimistic but pessimistic. It depends on each application.