Peter
You could create a table (ctrlTable) with the following columns
computerName TEXT 25
DateTimeIn DATETIME
DateTimeOut DATETIME
CONNECT YourDataBase
SET VAR vComputerName = (CVAL('Computer'))
SET VAR vRows INTEGER = 0
SEL COUNT(*) INTO vRows INDIC ivrows FROM ctrlTable WHERE computerName =
.vComputerName AND DateTimeOut IS NULL
IF vRows <> 0 THEN
PAUSE 2 USI 'Already Logged In' CAPTION 'TEST LOGIN' ICON STOP
GOTO Done
ELSE
INSERT INTO ctrlTable (computerName,DateTimeIn) .vComputerName,.#NOW
ENDIF
Make sure you update the DateTimeOut when exiting the database.
Buddy
________________________________
From: [email protected] on behalf of Peter J. Ryan
Sent: Wed 10/29/2008 4:35 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Mult-iusers, Multi-sessions, Mult-iPCs
We have several computers in a common counter area.
Users loggin to apps to assist customers. Sometimes at their own desk
Sometimes at the counter. Often at both places all day long.
I am trying to find a way to limit the use of the same database being opened
more than once on the same
PC. Timeout option doesn't seem to be the issue -- its preventing the start of
a session that already opened.
(Re-training users and/or replacing the staff is an option desired but -- I
really can't consider it now.)
I guess mystartup.dat is missing sometime. Suggestions?
