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/
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
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/171dceb0-087c-33f8-a1aa-ddafc3c51248%40wi.rr.com.
