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
