>I have two cursors A and B. Cursor A is the same structure as Cursor B.
>
>I created a formset, the setting for BufferMode is 2. When I run a formset, Cursor A and B are opened separately. I executed CURSORGETPROP() to return the buffering setting for two cursors, but the return values are different. Cursor A is 3, Cursor B is 5.
>
>Why?

the CURSORGETPROP function returns a number between 0 and 5 inclusive.
the BUFFERMODE property for a FORMSET only has 0,1,2.
you are sort of comparing apples to oranges here.


each cursor has a property called BUFFERMODEOVERRIDE whose numeric value has the same meaning as the numerical value you will receive from CURSORGETPROP

if BUFFERMODEOVERRIDE property is something other than 1 then the BUFFERMODE property in the formset is irrelevant

any cursor used by a grid control is enable for table buffering
any cursor whose data is bound to any other control will be activated for record buffering

my guess is that cursor B is used to populate a grid ...

and cursor A is bound to some other non-grid control


notice that buffermodes 3 and 5 both are "optimistic" modes
and that you asked for "optimistic" buffering with the BUFFERMODE FORMSET property


HTH ,
Dave.