Hi All,
In NAV 2106, you may have seen the SQL Timestamp Property added to Table Field.
Basically it stores a row version for every update in the table and it gets incremented every time you do a update. So you can identify the modified records from last time you checked.
You can check by creating a field as shown below, Data Type should be BigInteger.
and go to Field Property and set SQL Timestamp to Yes.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-ki4JGklY_w1s-EMqlavuKgPm_lMzEMNLVSG8JAzFZxvBYNQXZgUhvUhNIj4_dhWvRZ4EjdJdiWuCXZcRwxKa_ShVGJWlOaVT1bEyTev3Tv03pvf8n7nD8z1eWrXDfOqjRlSUClwNqMU/s640/csuttime.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUp3BOp6KmQVn8Q9cFznM4k4FHeMCUkECGGBspsNzNJBnKA5tmubMPmbnA17Hhv1qOwj0UZqTnAu4F2X0ra7U4kdeIgn-MR-I4hKH1k4L_t7m_IV-JPDgNECX3VJlx-RnGx7uzTx6AOgs/s640/Custvalue.png)
Thanks & Regards,
Nandesh Gowda
In NAV 2106, you may have seen the SQL Timestamp Property added to Table Field.
Basically it stores a row version for every update in the table and it gets incremented every time you do a update. So you can identify the modified records from last time you checked.
You can check by creating a field as shown below, Data Type should be BigInteger.
and go to Field Property and set SQL Timestamp to Yes.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-ki4JGklY_w1s-EMqlavuKgPm_lMzEMNLVSG8JAzFZxvBYNQXZgUhvUhNIj4_dhWvRZ4EjdJdiWuCXZcRwxKa_ShVGJWlOaVT1bEyTev3Tv03pvf8n7nD8z1eWrXDfOqjRlSUClwNqMU/s640/csuttime.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZR3_zf6SuSWjyIkBtYkzxF8Vh7U3b98Kw6drlakVfutXMfPrQwXd4_BQRGron6xMqfqKtl_sAaGvNA-T_G_U41XpqNLMhlqxmofgekXqyI4pl1EhQRKEr7F16mOiXZB7Nw2gtqvg8C-o/s640/sqltimest.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUp3BOp6KmQVn8Q9cFznM4k4FHeMCUkECGGBspsNzNJBnKA5tmubMPmbnA17Hhv1qOwj0UZqTnAu4F2X0ra7U4kdeIgn-MR-I4hKH1k4L_t7m_IV-JPDgNECX3VJlx-RnGx7uzTx6AOgs/s640/Custvalue.png)
Thanks & Regards,
Nandesh Gowda
No comments:
Post a Comment