Emmitt, Very specfically in Dan's case the variables are derived from the same table via a SELECT INTO. My thinking is there could be some weird interacting. This is after all v6.1A for DOS.
Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 --- On Tue, 7/22/08, Emmitt Dove <[EMAIL PROTECTED]> wrote: > From: Emmitt Dove <[EMAIL PROTECTED]> > Subject: [RBASE-L] - RE: Strange Multi-user Behavior > To: "RBASE-L Mailing List" <[email protected]> > Date: Tuesday, July 22, 2008, 2:32 PM > James, > > I think I read you to indicate that two users with the same > variable could > impact each other's values. If that was not your > intent, then this response > is moot. > > Variables are global, but only to the user, since they are > maintained in the > user's RAM. If user A has the same form open as user > B, their variables > will not interact directly. However, if the variables are > form variables > that are derived from values on the table in question, the > users are editing > the same row, one of them changes a value that impacts the > other user's > variable(s), and the other user's form is REFRESHed, > then there could be an > issue. Pretty unlikely, I'd think. > > Emmitt Dove > Manager, DairyPak Business Systems > Evergreen Packaging, Inc. > [EMAIL PROTECTED] > [EMAIL PROTECTED] > (203) 643-8022 > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of James > Bentley > Sent: Tuesday, July 22, 2008 2:42 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: Strange Multi-user Behavior > > David, > > I have been thinking about this problem. In RBase all > variables are global > thus one user could change a value set by another user. > Also, in multi-user mode checkout the refresh value. > > Possibly your users are interacting because they share > variables and a > refresh is taking place. > > Jim Bentley > American Celiac Society > [EMAIL PROTECTED] > tel: 1-504-737-3293 > > > --- On Wed, 7/16/08, David Blocker > <[EMAIL PROTECTED]> wrote: > > > From: David Blocker > <[EMAIL PROTECTED]> > > Subject: [RBASE-L] - RE: Strange Multi-user Behavior > > To: "RBASE-L Mailing List" > <[email protected]> > > Date: Wednesday, July 16, 2008, 8:26 PM > > Dan > > > > > > > > Thanks for responding - I was beginning to think my > email > > got lost in the ether.. > > > > > > > > Here's the code that both users share: > > > > > > > > SEL lname, fn, memstat, suspend1, expell, profname, > > nickname + > > > > stbal INTO vln IND v1, vfn IND v2, vm IND v3, vsus IND > v4, > > + > > > > vexp IND v5, vprof IND v6, vnick IND v7, vwkdue IND v8 > FROM > > persdata + > > > > WHERE ss# = .vss > > > > --grab just first letter of memstat. KAD for David > Blocker > > 07/10/1997 > > > > SET VAR VM = (LJS(.VM,1)) > > > > SEL MAX qtr INTO vquart IND v8 FROM dues WHERE ss# = > .vss > > > > SEL SUM duespd INTO vpd IND v9 FROM dues WHERE + > > > > (ss# = .vss AND qtr = .vquart) > > > > SET VAR vs1 = (SGET(.vss,3,1)), vs2 = > (SGET(.vss,2,4)),+ > > > > vs3 = (SGET(.vss,4,6)) > > > > CLS > > > > SET NULL " " > > > > DISPLAY mem IN main45.apx at 2 > > > > SET VAR v2s = (.vs1 + "-" + .vs2 + > "-" > > + .vs3) > > > > CLE VAR vs1, vs2, vs3, v1, v2, v3, v4, v5, v6, v7, v8, > v9 > > > > WRI .vln AT 2 8 YELLOW ON BLUE; WRI .v2s AT 2 43 > YELLOW ON > > BLUE > > > > WRI .vwkdue AT 2 69 YELLOW ON BLUE > > > > WRI .vfn AT 3 8 YELLOW ON BLUE > > > > IF vNick IS NOT NULL THEN > > > > WRI .vNick AT 3 30 LIGHT GREEN ON GRAY BLINK > > > > ENDIF > > > > WRI .vm AT 3 53 YELLOW ON BLUE > > > > WRI .vquart AT 3 67 YELLOW ON BLUE; WRI .vpd AT 3 73 > YELLOW > > ON BLUE > > > > WRI .vsus AT 4 10 YELLOW ON BLUE; WRI .vexp AT 4 28 > YELLOW > > ON BLUE > > > > WRI .vprof AT 4 50 YELLOW ON BLUE > > > > SET NULL -0- > > > > > > > > This puts the information on top of the screen, lines > 1- > > 4. The code following brings up another menu of > options, > > each of which leads to a form for entering or editing > some > > kind of data about the person displayed. The > > "flipping" happens randomly, and can happen > on > > either of the 2 workstations involved, with one user > in a > > menu, or on a form. > > > > > > > > David Blocker > > > > > > > > David Blocker > > [EMAIL PROTECTED] > > Telephone: 781-344-1920 > > Cell Phone: 339-206-0261 > > ----- Original Message ----- > > From: Dan > > To: RBASE-L Mailing List > > Sent: Sunday, July 13, 2008 9:26 PM > > Subject: [RBASE-L] - RE: Strange Multi-user Behavior > > > > > > Hi David, > > You are right, this shouldn't happen the way > you > > explained it. > > Can you give an example of the code that does this > > lookup for both users? > > > > Dan > > > > > > At 02:25 PM 7/13/2008, you wrote: > > > > Hello David, > > I am not sure if this is applicable but it popped > into > > my head as I think of common issues between users. > > > > . Is the scratch folder for temporary > files > > their local computer or the same for all on the > server? > > . REFRESH <> 0 (Maybe?) > > . Display command? > > . Maybe something in the rbase.cfg file > if it > > is being shared among users? > > > > I hope at least it sparks a new venue of thought > in > > your troubleshooting process. > > Good luck, > > Manuel > > > > > > > ---------------------------------------------------------------------------- > > > > From: [email protected] [ > mailto:[EMAIL PROTECTED] On > > Behalf Of David Blocker > > Sent: Wednesday, July 09, 2008 12:03 PM > > To: RBASE-L Mailing List > > Subject: [RBASE-L] - Strange Multi-user Behavior > > > > Dear Friends > > > > I have some very strange behaviour going on in a > > multi-user application that I've never encountered > > before. > > > > Application: still on R:Base 6.1a for DOS (upgrade > in > > progress) > > > > User A: selects a menu item that just LOOKS UP > > variables and DISPLAYS the variables on the screen > > information about a member in the organization: say > Alan > > Adams. This data is NOT on a form - just using WRITE > > commands to put variables on the screen > > > > The code then does NOT refresh that display, but > > displays either a menu of choices under the display > or a > > form with data from a different table. > > > > User B: Selects the same menu item: diplays a > > different user in the same fashion, say Ben Billings > > > > User A - SOMETIMES - not always by any means - > will now > > look up at the screen, having taken NO action on the > > keyboard, and finds that Alan Adams' info has been > > replaced by Ben Billings' > > > > I can't even begin to conceive how this could > > happen!!! Any ideas? > > > > David Blocker > > > > [EMAIL PROTECTED] > > Telephone: 781-344-1920 > > Cell Phone: 339-206-0261 > > > > Thanks, > > > > Dan > > > > Dan Champion > > Information Services > > Vredevoogd Heating > > 3047 Sangra SW > > Grandville, MI 49504 > > (616) 534-8271 x10 > > > > Or > > > > Dan Champion > > Champion Solutions > > 1415 Laughlin Dr. > > Grand Rapids, MI. 49504 > > (616) 453-7225 > > ICQ 6686404 > > > > No virus found in this incoming message. > > Checked by AVG - http://www.avg.com > > Version: 8.0.138 / Virus Database: 270.4.10/1551 - > Release > > Date: 7/14/2008 6:49 AM
