Radicore Forum: Bug Reports » SQL Server @@IDENTITY

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

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Server @@IDENTITY [message #5893]

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/

Report message to a moderator

Re: SQL Server @@IDENTITY [message #5895 is a reply to message #5893]

Tue, 27 September 2016 05:38

AJM
Messages: 2371
Registered: April 2006
Location: Surrey, UK

Senior Member

I have applied this change, and it will be available in the next release.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Tue Dec 03 13:37:04 EST 2024

Total time taken to generate the page: 0.01172 seconds