Hi Jeff,
Technically ...
The data that populates the values for SYS_TABLES actually comes from
the "1" file. You will not find any rows for SYS_TABLES in file
"2". Each row for SYS_TABLES is actually created on the fly from
the information in file "1". When we added the last structure
modification value, we did not modify the structure of SYS_TABLES.
We did add an interface function for the front end so that it can get
the last structure modification for and table or view.
It would be nice to add a new function which could provide the last
structure modification timestamp for a given table or view. It would
look something like this:
SET VAR LMOD DATETIME = (LASTMOD('tablename'))
Hope that explains.
Very Best R:egards,
Razzak
At 05:05 PM 1/11/2019, Richardson, Jeff wrote:
Hello. I'm using RBase X Enterprise here. I know that I can find out
the last datetime that a table structure was modified through the
Database Explorer > Tables; or by typing LIST tablename at the R>Prompt.
However, I am wanting to capture this value, but, curiously, I
cannot find a column in SYS_TABLES or any other system table that
holds this data.
Does anyone know where this data is stored?
Thanks!
Jeff Richardson | Project Manager, Asset Verification Services (AVS)
--
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].
For more options, visit https://groups.google.com/d/optout.
