>>>>>>[...] 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 ?