The timestamp column

allanp

Hi all

Is the (binary) timestamp column always increased over time - even across records and tables? That is, if I e.g. change customer AA and then change customer BB, will the timestamp for BB be "larger" than the one for customer AA? And is it also the case if I change a record in an other table? E.g. change Contact CC after customer BB, will the timestamp for Contact CC be "larger" than the timestamp for customer BB?

I am asking because one of my customers have created their own replication of customers from Navision to an other application using a DTS job. And the main criteria for replicating a customer is if the timstamp is larger than the largest of timestamps allready replicated - in theory modified since last replication. I just want to make sure that this actually allways will be the case.

Thanks
/Allan

nunomaia

TimsStamp is increased every time a records change happens, so I guess its safe to tell that. :-k

Check
http://www.mibuso.com/forum/viewtopic.php?p=97886

Waldo

The timestamp is used internally to simulate the versioning principle.. .

Marije_Brummel

Maybe it is better to create your own timestamp. That way you will know exactly how it behaves.

It's not rocketscience...