Don't forget to SET MULTILOCKS ON before you set buffering. I open all tables in the form's dataenvironment. In the BeforeOpenTables event I call this function in the application start up program:
FUNCTION SetLocalEnvironment(tlExclusive) As VOID IF NOT tlExclusive SET EXCLUSIVE OFF ELSE SET EXCLUSIVE ON ENDIF SET DELETED ON SET DATE BRITISH SET CENTURY ON SET HOURS TO 24 SET CURRENCY TO "£" SET COLLATE TO "GENERAL" SET MULTILOCKS ON && Essential for Buffering SET TALK OFF SET SECONDS OFF SET ANSI ON SET NULLDISPLAY TO "?" ENDFUNC Laurie On 24 September 2014 04:52, Fred Taylor <[email protected]> wrote: > As far as explicitly opening the table the grid uses, that's my prefered > way of doing things. I'd much rather be in control. > > If all the tables that this form will use need buffering,you could set the > buffering in the form.Load using CURSORSETPROP() with the last parameter as > 0, allowing all subsequent USE/auto open statements to be set to the > buffering you chose. > > Fred > > On Tue, Sep 23, 2014 at 6:14 PM, Gene Wirchenko <[email protected]> wrote: > > > At 15:56 2014-09-22, Fred Taylor <[email protected]> wrote: > > > >> Somewhere after the tables are opened/cursors created.. Depends on > >> how/where you open the tables. (Form.Init, Form.Load, DataEnvironment, > >> etc). > >> > > > > Well, I had it in the form's load, but I started getting the error > > about setting buffering when my code tried tableupdate(). > > > > I do not explicitly open the table. It is done by setting the > grid's > > recordsource. > > > > Should I explicitly open the table, too? > > > > [snip] > > > > > > Sincerely, > > > > Gene Wirchenko > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAMvTR9eW2n08_dUq_WStt0-gRgo7=vihxpc6pngfkpefjgg...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
