Identity return failure

[BomberMan2K]

Hi,
I'm moving to MSSQL2005 from Access and having a small problem.
I use ASP and ADO to work with MSSQL.
When i create a new record through ASP, in a table which has an identity column - i can't get the identity column which is generated automaticaly.
After I update the newly created record, i should have access to each of it's fields and should be able to retrieve the info - which is not possible for me with the identity field.
This problem was not present when using Access, and also wasn't present when i just moved to MSSQL - it's something new.
The code itself is 100% O.K - it works fine with Access DBs.

What could be the problem and how can it be solved?

Thank you very much.

 

[ca8msm]

Have a look at the scope_identity method.


------------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions

 

[BomberMan2K]

Thanx, it's exactly what i needed.