Print Page | Close Window

IDENTITY crisis :-)

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5353
Printed Date: 02 June 2025 at 9:10pm


Topic: IDENTITY crisis :-)
Posted By: mikek
Subject: IDENTITY crisis :-)
Date Posted: 06 October 2005 at 6:06am

Roberto:

would it be possible for you to use SELECT SCOPE_IDENTITY() instead of SELECT @@IDENTITY after your SQL INSERTS?

I am trying to add an INSERT trigger to the tblMSGs Table which itself inserts another record into another table, but by doing so, it breaks the following INSERT to the tblQuarantine Table because @@IDENTITY will return the identity of the record inserted by the trigger.

Thanks,

Mike


Replies:
Posted By: LogSat
Date Posted: 06 October 2005 at 10:46pm
Sorry Mike, SpamFilter makes generic ADO calls to the data components. It's then the data libraries that translate the calls to SQL specific command for the database platform used. We're not able to currently control the exact SQL language being used.

-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP


Print Page | Close Window