Radicore Forum: Bug Reports » SQL Server @@IDENTITY

Home » RADICORE development » Bug Reports » SQL Server @@IDENTITY

Tue, 27 September 2016 01:02

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/

		SQL Server @@IDENTITY By: kong on Tue, 27 September 2016 01:02
		Re: SQL Server @@IDENTITY By: AJM on Tue, 27 September 2016 05:38

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

Goto Forum:

] [

]

Current Time: Sat Apr 27 08:26:50 EDT 2024

Total time taken to generate the page: 0.09172 seconds