Error while using Scope_Identity() instead of @@identity. WHY?

N

nashak

Hello everyone,

I am trying to get back the primary key and was using @@identity
without any problem. However, when I use scope_identity() I get the
following error.


"Cast from type 'DBNull' to type 'Integer' is not valid."
Please help.


Thanks
 
P

Patrice

Seeing some code may help. It looks like the value is not returned correctly
and is NULL instead of the expected value...

Patrice
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scope_Identity returning Decimal for an Integer field 16
Using Scope_Identity with a data adapter 2
Getting Identity back 5
Sql Server SCOPE_IDENTITY() 11
When is 19 Not an Integer 3
SCOPE_IDENTITY and parameters during insert 6
scope_identity() issues. 4
How do you pass NULLs to SQL via an Insert Statment 4

Top