Why would you want to lock a table? Dan Goldberg
Dan Goldberg MIS Manager Lance Campers ________________________________ From: [email protected] <[email protected]> on behalf of Doug Hamilton <[email protected]> Sent: Tuesday, March 3, 2020 4:17:11 PM To: R:Base List <[email protected]> Subject: [RBASE-L] - Table locks 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. -- 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/BN8PR06MB5346BEF8414A412CDB67C811AAE50%40BN8PR06MB5346.namprd06.prod.outlook.com.
