Navision Timestamp for caching

mrettler

Hi there,
does Navision provide a Timestamp or something like that to see when the last change was done on a dataset?

rmv_RU

Not using Nav code. But you can use SQL to compare timestamp of investigating record and Change Log.

declare @t bigint
select @t=cast(timestamp) as bigint from table
select top 100 * from [company$Change Log Entry] where cast(timestamp as bigint)>=@t
order by cast(timestamp as bigint)

Sometimes it can be useful.

rmv_RU

Not using Nav code. But you can use SQL to compare timestamp of investigating record and Change Log.

declare @t bigint
select @t=cast(timestamp) as bigint from table
select top 100 * from [company$Change Log Entry] where cast(timestamp as bigint)>=@t
order by cast(timestamp as bigint)

Sometimes it can be useful.