Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Function Index > C > CVAL

LAST_MOD

Scroll Prev Top Next More

(CVAL('LAST_MOD'))

 

Returns the date and time stamp for the last modification made to the database data. The value is saved in the database immediately when data 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 modification value.

 

The CVAL function returns a TEXT value for the date and time stamp. To get the last data modification into a DATETIME variable, you may perform the following:

 

SET VAR vLastMod_Text TEXT = (CVAL('LAST_MOD'))

SET VAR vLastMod_DateTime DATETIME = .vLastMod_Text