(CVAL('LAST_SCHEMA_MOD'))
Returns the date and time stamp for the last modification made to the database schema. The value is saved in the database immediately when the schema has changed, and does not require a user to disconnect from the database in order for the date and time stamp value to be altered. The value is also displayed with the LIST command.
When you connect to database which does not have this value stored yet, the date and time stamp from the RX1-RX4 file synchronization will be used as the initial last schema modification value.
The CVAL function returns a TEXT value for the date and time stamp. To get the last schema modification into a DATETIME variable, you may perform the following:
SET VAR vLastSchemaMod_Text TEXT = (CVAL('LAST_SCHEMA_MOD'))
SET VAR vLastSchemaMod_DateTime DATETIME = .vLastSchemaMod_Text
