Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Last Autonumber		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

kolucoms6
Average Member

845 Posts
Posted - 19 May 2007 :  05:53:07  Show Profile

After executing Insert Query using adCn.execute sSql

I want to get the Autonumber generated for the same.

I did it in past but just cant recall how to get it.

Any Help ?

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 19 May 2007 :  05:58:26  Show Profile  Visit HuwR's Homepage
use "select @@IDENTITY"
Go to Top of Page

kolucoms6
Average Member

845 Posts
Posted - 19 May 2007 :  06:02:56  Show Profile
Ok..Let me try it...

Works in MS-Access ?
Edited by - kolucoms6 on 19 May 2007 06:03:53
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 19 May 2007 :  06:32:12  Show Profile  Visit HuwR's Homepage
quote:
Works in MS-Access ?
no idea
Go to Top of Page

kolucoms6
Average Member

845 Posts
Posted - 19 May 2007 :  09:03:18  Show Profile

Worked.Thanks.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.26 seconds. Powered By: Snitz Forums 2000 Version 3.4.07