At 06:30 PM 3/8/2008, Heffelfinger, Duane wrote:
Are there "hidden" columns attached to all tables that can be accessed, such as the date and time a row was entered, accessed, etc.?
No. However, if you have ever used Oterro to generate or alter tables you may have noticed that those tables get a new column added to the end. The SYS_ROWVER column. The SYS_ROWVER column is a computed integer column that contains the version of the row. Its formula is as follows: (IFNULL((SYS_ROWVER+1),0,(SYS_ROWVER+1))). This translates to the following: If the existing SYS_ROWVER is null then the row version is one. Otherwise increment the row version by one. This is used, in most cases, by outside programs that do not have access to the internal R:BASE Concurrency system (Table Locking, Row Locking, Qualcols, Column vs Row Verification and so on.) For this reason, Oterro defaults to AUTOROWVER ON and R:BASE defaults to OFF. When AUTOROWVER is ON any CREATE TABLE or ALTER TABLE adds the SYS_ROWVER column to the table being altered or created. In your specific scenario, to keep track of a row inserts and edits, you may consider adding a computed DATETIME column with conditional functions to achieve your goal. Very Best R:egards, Razzak.
