Doug,
When a manual lock is applied to a view, via SET LOCK ViewName ON,
locks are placed on the table(s) defined within that view.
Just as with SET LOCK TableName ON, the command is available to
assign exclusive use of tables.
Very Best R:egards,
Razzak
At 06:25 PM 3/31/2020, Doug Hamilton wrote:
Razzak - Great job updating the table locks and providing the
associated functions and additional information in the LIST command.
But what does a view lock do?
Does it lock the underlying table in an updatable view to prevent
other users from updating the table?
Does it lock the data in a view to prevent it from updating if data
in the underlying tables is updated - like providing a snapshot of
the view's data?
or... ?
TIA
Doug
On 3/31/2020 5:46 AM, A. Razzak Memon wrote:
Tuesday, March 31, 2020
Tip of the Day: New CVAL Function to Show Locks on Views
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.2.20312 or higher
Sections......: Functions
Keywords......: CVAL, Lock, View, VIEWLOCKS
Did you know an added CVAL function has been implemented to show locks
on views?
The (CVAL('VIEWLOCKS')) function returns a delimited text string for
all views with a lock.
Example:
SET VAR vViewLocks VARCHAR = (CVAL('VIEWLOCKS'))
SHOW VAR vViewLocks
InvoicesMaster,ProductInvoice,StaffByDept
The function is an accompaniment to (CVAL('TABLELOCKS')), which returns
a delimited text string for all tables with a lock.
Example:
SET VAR vTableLocks VARCHAR = (CVAL('TABLELOCKS'))
SHOW VAR vTableLocks
Contact,Customer,InvoiceDetail,InvoiceHeader
Very Best R:egards,
Razzak.
https://www.rbase.com
http://www.facebook.com/rbase/
--
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/202004022059.032KxwJk017240%40atl4mhob11.registeredsite.com.
