Mike, My eyes just glazed over. Could you elaborate a bit more? I mean, storing the RFF as a varchar. Then deleting it from the temp file. Which file would I delete?
This sounds way cool if I can understand you fully. Jan -----Original Message----- From: "MikeB" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 3 Nov 2009 18:27:21 -0500 Subject: [RBASE-L] - RE: Qualcols 2 vs 10, what do you give up by changing from 2 to 10? Well.... up till about 6 months ago, the RUN SELECT would fail during the ON CONNECT, but thanks to the RBTI worker bees it got fixed. What that allowed you to do is store your RFF form as a VarChar so you could set it to a Variable, write it to disk (the users TEMP folder preferably) then display it. During the onAFTER EEP, you can delete the diskfile because the RFF is running in memory. What this whole thing was about was the Startup form would always come up when the DB started, preventing the user from getting at the Design UI. IN the RFFs onEXIT eep, you can put a Dialog asking for Password to allow you go go to the Design UI (RETURN) and if it isn't provided, then EXIT is executed closing the DB. It locks the DB from tampering period. ----- Original Message ----- From: "Emmitt Dove" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, November 03, 2009 6:09 PM Subject: [RBASE-L] - RE: Qualcols 2 vs 10, what do you give up by changing from 2 to 10? > |-) > > I was wondering how you could get setting from the db required before > connecting to the db before connecting to the db ... > > Emmitt Dove > Manager, Converting Applications Development > Evergreen Packaging, Inc. > [email protected] > (203) 214-5683 m > (203) 643-8022 o > (203) 643-8086 f > [email protected] > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of MikeB > Sent: Tuesday, November 03, 2009 5:54 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: Qualcols 2 vs 10, what do you give up by changing > from 2 to 10? > > Yes, my bad... You are right. > > We made it so you can RUN SELECT in the ON CONNECT or ON FIRST CONNECT, > but > > it won't work in the ON BEFORE CONNECT. > > > > ----- Original Message ----- > From: "Emmitt Dove" <[email protected]> > To: "RBASE-L Mailing List" <[email protected]> > Sent: Tuesday, November 03, 2009 3:30 PM > Subject: [RBASE-L] - RE: Qualcols 2 vs 10, what do you give up by changing > from 2 to 10? > > >> But Mike, those need to be set prior to CONNECT. I put them in a startup >> .DAT file. >> >> >> Emmitt Dove >> Manager, Converting Applications Development >> Evergreen Packaging, Inc. >> [email protected] >> (203) 214-5683 m >> (203) 643-8022 o >> (203) 643-8086 f >> [email protected] >> >> -----Original Message----- >> From: [email protected] [mailto:[email protected]] On Behalf Of MikeB >> Sent: Tuesday, November 03, 2009 2:13 PM >> To: RBASE-L Mailing List >> Subject: [RBASE-L] - RE: Qualcols 2 vs 10, what do you give up by >> changing >> from 2 to 10? >> >> And All of these settings can avoid being overwritten by config files by >> setting them using ON FIRST CONNECT Run cmdFile (or RUN SELECT if you >> want >> to store them in the DB) >> >> >> >> ----- Original Message ----- >> From: "Emmitt Dove" <[email protected]> >> To: "RBASE-L Mailing List" <[email protected]> >> Sent: Tuesday, November 03, 2009 1:48 PM >> Subject: [RBASE-L] - RE: Qualcols 2 vs 10, what do you give up by >> changing >> from 2 to 10? >> >> >>> I'll say it one more time - if you run in a multi-user environment, then >>> you >>> really should do the following, in this order, upon startup: >>> >>> >>> >>> SET MULTI ON >>> >>> SET STATICDB ON >>> >>> SET FASTLOCK ON >>> >>> SET QUALCOLS 2 >>> >>> CONNECT dbname >>> >>> >>> >>> Now, the MULTI ON can really be done anywhere before the CONNECT, but >>> the >>> others need to be in sequence. >>> >>> >>> >>> Emmitt Dove >>> >>> Manager, Converting Applications Development >>> >>> Evergreen Packaging, Inc. >>> >>> [email protected] >>> >>> (203) 214-5683 m >>> >>> (203) 643-8022 o >>> >>> (203) 643-8086 f >>> >>> [email protected] >>> >>> >>> >>> From: [email protected] [mailto:[email protected]] On Behalf Of Paul >>> InterlockInfo >>> Sent: Tuesday, November 03, 2009 12:34 PM >>> To: RBASE-L Mailing List >>> Subject: [RBASE-L] - RE: Qualcols 2 vs 10, what do you give up by >>> changing >>> from 2 to 10? >>> >>> >>> >>> From RBTI regarding Qualcols Settings "Command Index.pdf" they state the >>> following. >>> >>> >>> >>> Use QUALCOLS to choose page or row locking. The settings for QUALCOLS >>> are: >>> >>> . 2 - R:BASE uses a fast row-locking method. When QUALCOLS is set to 2, >>> you >>> can lock rows of data >>> >>> instead of locking a page of data. You increase multi-user performance >>> when >>> QUALCOLS is set to 2 and >>> >>> STATICDB and FASTLOCK are on. >>> >>> . 10 - R:BASE uses page locking. When QUALCOLS is set to 10 and two or >>> more >>> users are updating rows >>> >>> within the same page of data, R:BASE only lets the first user update >>> rows--the other users are locked >>> >>> out until the first user's update has been completed. >>> >>> >>> >>> >>> >>> I suppose it depends on your environment. >>> >>> >>> >>> Sincerely, >>> >>> Paul D. >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> From: [email protected] [mailto:[email protected]] On Behalf Of Victor >>> Timmons >>> Sent: Tuesday, November 03, 2009 11:27 AM >>> To: RBASE-L Mailing List >>> Subject: [RBASE-L] - RE: Qualcols 2 vs 10, what do you give up by >>> changing >>> from 2 to 10? >>> >>> >>> >>> I just did the same thing. WOW what a difference. I hope I'm not giving >>> anything else up by doing this. >>> >>> >>> >>> Victor Timmons >>> >>> Tiz's Door Sales, Inc >>> >>> Visit us at www.tizdoors.com >>> >>> P Please consider the environment before printing this e-mail >>> >>> _____ >>> >>> From: [email protected] [mailto:[email protected]] On Behalf Of Michael >>> J. >>> Sinclair >>> Sent: Monday, November 02, 2009 3:38 PM >>> To: RBASE-L Mailing List >>> Subject: [RBASE-L] - Qualcols 2 vs 10, what do you give up by changing >>> from >>> 2 to 10? >>> >>> >>> >>> Hi all, >>> >>> I just changed the setting of Qualcols from 10 (the default) to 2 and I >>> got >>> a significant improvement in my network peformance...many less pauses >>> and >>> hang ups. >>> >>> >>> >>> What do I lose by changing it from 10 to 2? What was the reason for >>> having >>> the default value of 10? >>> >>> >>> >>> Mike >>> >>> >> >> > >
