Thursday, February 7, 2019
Tip of the Day: New LASTMOD Function
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.1.30117 or higher
Sections......: Functions
Keywords......: Table, View, Structure, Timestamp, Modified
Did you know you can capture the structure modification timestamp for a
table or view?
The LASTMOD function has been implemented to provide the last structure
modification date and time value for a given table/view. The returned
DATETIME value will be formatted based upon the database settings.
SET VAR vInvHdrLastMod DATETIME = (LASTMOD('InvoiceHeader'))
SHOW VAR vInvHdrLastMod
10/30/2018 08:30 AM
SET VAR vTaskLastMod DATETIME = (LASTMOD('Tasks'))
SHOW VAR vTaskLastMod
01/18/2019 10:50 AM
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
