IDENTITY crisis :-) |
Post Reply 
|
| Author | |
mikek 
Senior Member 
Joined: 22 February 2005 Location: Switzerland Status: Offline Points: 133 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: IDENTITY crisis :-)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 |
|
 |
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.459 seconds.