What about the set refresh and set reprocess settings, any opinion on those base on my other settings? James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: [EMAIL PROTECTED]
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions General Account Sent: Monday, June 09, 2008 10:47 AM To: ProFox Email List Subject: Re: Form settings in Load Jim Harvey wrote: > These are the settings in the load of most of my forms that I began using > years ago when I went from DOS to VFP5. > > Now, most forms use buffering set to 5 on the tables in the load, = > cursorsetprop("Buffering",5,"STALLIONS"), some are set to 3. > > We have about 20 users, and everything seems to work fairly well, most of > the time. > > How out of date are these settings, and what's a better way to set this up, > or since nothing is "broke" should I not "fix it"... > > > > set century on > set talk off > set refresh to 0,0 > set reprocess to 1 > set safety off > set exclusive off > set deleted on > set multilocks on > set status bar off > set escape on > on escape > on error do ERRTRAP with error() Well, my answer is as you last said: "or since nothing is 'broke' should I not 'fix it'..." Moving forward, I would avoid row buffering like the plague due to implicit consequences if you move the record pointer. The other SET statements you have above seem fine. Here are the SET statements that I use in my latest apps: PROCEDURE DoSets() * Establish all SET values SET CENTURY TO 19 ROLLOVER 30 SET CURRENCY TO "$" IF _vfp.StartMode = 0 THEN SET TALK ON SET STATUS ON SET STATUS BAR ON SET CONSOLE ON SET SECONDS ON ELSE SET TALK OFF SET STATUS OFF SET STATUS BAR OFF SET CONSOLE OFF SET SECONDS OFF ENDIF && _vfp.startmode = 0 SET ESCAPE OFF SET DELETED ON && mjb 06-07-05 was off SET EXCLUSIVE OFF SET CONFIRM ON SET SAFETY OFF SET MULTILOCKS ON SET EXACT ON SET HOURS TO 12 SET NEAR OFF SET ODOMETER TO 1000 SET RESOURCE ON ENDPROC && DoSets() [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** 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.
