Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Bug Reports » SQL Server @@IDENTITY
SQL Server @@IDENTITY [message #5893] Tue, 27 September 2016 01:02 Go to previous message
kong is currently offline  kong
Messages: 90
Registered: December 2011
Member
Had to replace "SELECT @@IDENTITY" with "SELECT SCOPE_IDENTITY()" in dml.sqlsrv.class.inc, because @@IDENTITY returned Auto Increment value from other tables due to the table being part of an existing system with built-in triggers. For reference: https:// blogs.msdn.microsoft.com/spike/2009/10/20/my-take-on-identit y-vs-scope_identity/
 
Read Message
Read Message
Previous Topic: UPDATE1 scrolling skips validation after SubmitNext
Next Topic: Documentation deleteRecord
Goto Forum:
  


Current Time: Wed Dec 11 17:04:14 EST 2024

Total time taken to generate the page: 0.01026 seconds