SQL Timestamp in NAV

Each table i NAV contains a hidden field called timestamp. This is a rowversion or counter that always counts up, when records is modified og inserted.
Until NAV 2016, we could not access this field from NAV. This has changed.
The field is read-only, but besides that, it can be used like any normal field for filtering etc.

A typical use of the timestamp field is for synchronizing data changes in tables, when you want to identify records that have changed since the last synchronization. For example, you can read all the records in a table, and then store the highest timestamp value. Later, you can query and retrieve records that have a higher timestamp value than the stored value.

Create a new field in any table of type BigInteger.
Change SQLTimeStamp property to Yes.

Timestamp1

Timestamp2

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s