Sunday, July 5, 2009 Tip of the Day #6: Tracking Date/Time and Version Information Version: R:BASE eXtreme 9.0 (64) Build: 9.0.1.10701 and higher Section: Features and Enhancements (Database Explorer)
Did you know that you can track the Date/Time and Version information of Stored Procedures, Forms, Reports, and Labels in R:BASE eXtreme 9.0 (64) using the Database Explorer? In addition to SYS_PROC_VERSION (INTEGER) & SYS_PROC_MOD_TS (DATETIME) for SYS_PROCEDURES, R:BASE eXtreme 9.0 (64) now includes the following additional columns for SYS_FORMS3, SYS_LABELS3, and SYS_REPORTS3 to keep track of date/time as well as the revision number of modified Forms, Labels, and Reports. Additional SYS_ Columns: . SYS_FORMS3 (SYS_FORM_MOD_TS, SYS_FORM_VERSION) . SYS_LABELS3 (SYS_LABEL_MOD_TS, SYS_LABEL_VERSION) . SYS_REPORTS3 (SYS_REPORT_MOD_TS, SYS_REPORT_VERSION) These columns are updated when saving the form, label or report while in form, label or report designers accordingly. Database Explorer will reveal the Date/Time and Version. http://www.rbaseeXtreme.com/DBExplorer/DBExplorer_SP.png http://www.rbaseeXtreme.com/DBExplorer/DBExplorer_Forms.png http://www.rbaseeXtreme.com/DBExplorer/DBExplorer_Reports.png http://www.rbaseeXtreme.com/DBExplorer/DBExplorer_Labels.png Hint: While in Form Designer, when running or previewing the form, the form is automatically saved, thus stamps the date/time as well as increases the version count. If you wish to change this behavior and only stamp the date/time and increase the version count when you click on the [Save] button in Form Designer, you may change the Form Designer settings as follows: Database Explorer | Main Menu | Settings | Form Designer ... http://www.rbaseeXtreme.com/DBExplorer/Form_Settings01.png http://www.rbaseeXtreme.com/DBExplorer/Form_Settings02.png Have fun! Very Best R:egards, Razzak.
