>>>>>>>[...] in order to set a table's buffering to any mode other than 0 (zero), SET MULTILOCKS must be ON. [...] you can't turn on any buffering with SET MULTILOCKS OFF. (As the help and docs on buffering say.)
>>>>>>>
>>>>>>>My US$.02 worth.
>>>>>>
>>>>>>Does it default to on or something? I never set multilocks to anything and I've got buffering on almost all my tables. I set it in the DE or set the form's default, so maybe it's doing it for me?
>>>>>
>>>>>Er, um, ahh ... that's a good question ... no, it defaults to OFF ... do you have MULTILOCKS=ON in your config.fpw? Did you, in Tools/Options/Data tab, check the box which says Multiple record locks, and click the "Set As Default" button?
>>>>>
>>>>>Cheers,
>>>>
>>>>I don't have a config, and the options one is not checked.
>>>>
>>>>-Michelle
>>>
>>>Help: "MULTILOCKS must be ON to before row or table buffering can be enabled with CURSORSETPROP( )".
>>>Does it mean that in other situations (i.e. you don't use CURSORSETPROP) you should not bother?
>>
>>That seems to be the case. I don't use CURSORSETPROP. All my buffering is through the DE or through the form default. I just double checked my "SET" code and it's not in there.
>>
>>-Michelle
>
>If you do DISPLAY STATUS in the Command Window, do you see MultiLocks = on ?

Nope. They're off.

-Michelle