>>>>CURSORSETPROP acts on an open cursor, it is not a universal setting. If you use a DataEnvironment, you can set buffering in the cursor objects there as well.<<<
>
>
>Erik, my problem I think is that I am not using a Data Environment. Can I programaticaly set the Dataenvoironment ? and if so where would be the best place and what commands would you suggest.
>
>Regards,
>
>Gerard
It depends on where you open your tables. Are you using private datasessions? If so, you can put
THISFORM.Buffermode = 2 && Optimistic
in the Form.Load event, and that will make the default buffermode for tables opened in that datasession optimistic. If you are using the default datasession, you just need to use CURSORSETPROP on each cursor when it is opened.
Erik Moore
Clientelligence