How to Return the SCOPE_IDENTITY from SQL to VB

[Jomercat]

Hi all,

Hope that somebody can help me with this.

I am developing an application in VB 6, which connects to a SQL 2000 server and executes a store procedure.

The store procedure is selecting the SCOPE_IDENTITY after inserting the record.

If I run the store procedure within SQL, it returns the last record inserted; however when I executed from VB, the record set does not return it.

Does anybody know how to return this value back to VB?

Any help would be appreciated.

Thanks in advance.

Jose.

 

[TysonLPrice]

Take a look here:

http://www.developerfusion.co.uk/show/91/4/

 

[Jomercat]

TysonLPrice,

Thanks for your reply.

I will review the link.

Jose.