I can't get table locks to work.
I set a lock on a table on one computer.
On a different computer, LIST <tablename> shows a remote lock on that
table, sometimes.
In a block of code on the different computer, SET VAR vTableLocks =
(CVAL('TABLELOCKS')), vTableLocks is blank, sometimes.
I can't get enough consistent results/errors to know what questions to ask.
How long does it take for different workstations to see a table lock?
How does RBase determine who set the lock? USER - as in SET USER? NAME -
as in SET NAME? But NAME "must be saved to the configuration file"
(RBX.5 Help). But doesn't everybody read the the same CFG file and
would have the same name?
Below is test code, vTableLocks doesn't contain MoparSysParams even
though it is locked (local lock) on a different computer (yes, the
sessions of RBase are all in the same current folder).
Is there a difference between setting a local lock and a remote lock? I
thought a lock was a lock, local and remote was just a matter of
perspective of who set the lock.
SET VAR vTableLocks VARCHAR
LABEL TestLock
SET VAR vTableLocks = (CVAL('TABLELOCKS'))
IF (SLOC(.vTableLocks,'MoparSysParams')) <> 0 THEN
PAUSE FOR 2 USING 'Waiting for Pick Ticket Access'
GOTO TestLock
ENDIF
SET LOCK MoparSysParams ON
RETURN
TIA
Doug
RBx.5E
arrrgh
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/72ef7172-1993-8977-5079-7cdc16717937%40wi.rr.com.
