George,
I've tested further and the setting of alias didn't help nor the setting of the database. Here is my code:
set procedure to sesclass.prg
this.addobject('osession','ss')
with this.osession.ode
.addobject('ocursor1','cc')
.ocursor1.database='cc.dbc'
.ocursor1.cursorsource='vari'
.ocursor1.alias='vari'
.ocursor1.buffermodeoveride=0
.addobject('ocursor2','cc')
.ocursor2.database='cc.dbc'
.ocursor2.cursorsource='acct'
.ocursor2.alias='acct'
.ocursor2.buffermodeoveride=0
.ocursor2.order='acct'
.ocursor2.filter="type='1'"
.addobject('ocursor3','cc')
.ocursor3.database='cc.dbc'
.ocursor3.cursorsource='tran'
.ocursor3.alias='tran'
.ocursor3.buffermodeoveride=5
*----------open above tables
.opentables
endwith

If sesclas.prg would help let me know.


>>George,
>>After checking, same here with cursor.buffermodeoveride=5, but,
>> cursorgetprop("buffering")=1
>>Nothing I could think of would change that, except I finally used:
>>set multilocks on
>>select mytable
>>cursorsetprop("buffering",5)
>>and that worked.
>>
>Terry,
>
>You might try making that change and see if it does the trick. I'll test as well.