How can I get the timestamp column from SQL for a particular record in C/AL code. I need to write out the timestamp column to a database table before the modify and after the modify. How can I achieve this?
*This post is locked for comments
How can I get the timestamp column from SQL for a particular record in C/AL code. I need to write out the timestamp column to a database table before the modify and after the modify. How can I achieve this?
*This post is locked for comments
hi,
not directly from C/AL Code; timestamp is not nav phisical field (sql rowversion field)
two methods:
1) you could write a SQL Query using ADO.NET from with NAV to retreive TimeStamp value (.NET Interoperability).
2) you can access it with a SQL view and Nav linked table (consuming a NAV table and using a bigint number)
André Arnaud de Cal...
292,516
Super User 2025 Season 1
Martin Dráb
231,387
Most Valuable Professional
nmaenpaa
101,156