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 next 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/
Re: SQL Server @@IDENTITY [message #5895 is a reply to message #5893] Tue, 27 September 2016 05:38 Go to previous message
AJM is currently offline  AJM
Messages: 2028
Registered: April 2006
Location: Surrey, UK
Senior Member
I have applied this change, and it will be available in the next release.

Previous Topic: UPDATE1 scrolling skips validation after SubmitNext
Next Topic: Documentation deleteRecord
Goto Forum:
  


Current Time: Sun Mar 26 22:44:12 EDT 2017

Total time taken to generate the page: 0.07676 seconds