Thank you Razzak and Jim for the explanation and suggestions. I have requested a new enhancement to address my need through the R:DCC interface.
From: 'James Bentley' via RBASE-L <[email protected]> Sent: Monday, January 14, 2019 7:05 AM To: [email protected] Subject: Re: [RBASE-L] - Table Structure Modification Timestamp or perhaps an additional option for the The IINFO function . This function is 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]<mailto:[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<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].<mailto:[email protected].> For more options, visit https://groups.google.com/d/optout<https://groups.google.com/d/optout>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php<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]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout<https://groups.google.com/d/optout>. ATTENTION: This message and all attachments are PRIVATE, and may contain information that is CONFIDENTIAL and PRIVILEGED. If you have received this message in error, please notify the sender by reply e-mail and delete the message immediately. If you no longer wish to receive communication from DMA, please click here.<https://www2.dmainc.com/subscriptioncenter> -- 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.
