General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only