James
Ah, but you see that's just the point. First of all, values of variables in
R:Base are MACHINE SPECIFIC so that two machines can run the same program
and not mess each other up. "Global" doesn't mean across machines, it means
"values available in all modules of R:Base - forms, reports, views, etc.
Only DATA changes in the tables themselves should cross machine to machine.
Second of all, the variables in question are looked up ONCE, are written to
the screen and STAY there until the user escapes from the menu of choices.
But users are reporting that while they are still in the same loop of code,
AFTER the variables are written on screen, the values are changing!!
David
David Blocker
[EMAIL PROTECTED]
Telephone: 781-344-1920
Cell Phone: 339-206-0261
----- Original Message -----
From: "James Bentley" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, July 22, 2008 2:41 PM
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
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.5.4/1566 - Release Date: 7/22/2008
6:00 AM
