>
>Hi Suhas,
>
>Why do you think that making cursor transactable somehow connected to setting buffering to 5? In fact, if cursor is in table buffering mode, it can not be made transactable.
>
>
>I use them (in order not to create a sea of cursors).
>
>I use various SPT Cursors into a Private DS with this logic:
>- Buffering 5 for change statuses and local undo capability, value by value
>- when i have to validate a user input that change a field value,
>i open a temporary transaction, bacause this can change others cursors,
>if a business rule is violated the rollback this single operation.
>
>I cannot do this in VFP ?
>
>Thanks

Hi Fabio,

I am sorry, it is not clear for me what you are trying to ask.

SPT cursors transactable by default, don't they?
If a cursor is not transactable, table buffering should be switched off before it can be made transactable (I am talking about MAKETRANSACTABLE() function). After the cursor is made transactable, it can be switched to table buffering without any problem.

Does this answer your question? If not, please try to explain more clearly what is it you would like to do. Perhaps with some code examples.

Thanks,
Aleksey.