or perhaps an additional option for the The IINFO function . This functionis
used to return information about tables, columns, or indexes by reading
internal bitmask flags. The function requires the ID number for the table,
column, or index.
Jim Bentley, American Celiac Society 1-504-305-2968
On Saturday, January 12, 2019, 8:58:04 PM CST, A. Razzak Memon
<[email protected]> wrote:
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.
--
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.
