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
