Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - How to retreive the autonumber
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

How to retreive the autonumber
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
maniva View Drop Down
Groupie
Groupie
Avatar

Joined: 04 April 2002
Location: Italy
Status: Offline
Points: 82 		Post Options Post Options   Thanks (0) Thanks(0)   Quote maniva Quote  Post ReplyReply Direct Link To This Post Topic: How to retreive the autonumber
    Posted: 27 February 2003 at 12:22pm

Dear friends,
I've an asp page where I create a record in a Access table.
In that table I've a Key field that is autonumber.

How can I know which is the number just insered ?

Here the code that i've

If (strMode = "edit" OR strMode = "new") Then
 
  If strMode = "new" Then rsOpere.AddNew
   rsOpere.Fields("Author_id") = AutorId
  
   rsOpere.Update
    
End If

The field name in the table is ID 

Thank you in advance
Ivano Mangiarotti
Back to Top
MorningZ View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MorningZ Quote  Post ReplyReply Direct Link To This Post Posted: 27 February 2003 at 12:35pm
after your code:

if strMode = "new" then
Set rstIdent = connectionObject.Execute("SELECT @@IDENTITY")
ThisNewID = rstIdent(0)
Set rstIdent = Nothing
end if
Contribute to the working anarchy we fondly call the Internet
Back to Top
maniva View Drop Down
Groupie
Groupie
Avatar

Joined: 04 April 2002
Location: Italy
Status: Offline
Points: 82 		Post Options Post Options   Thanks (0) Thanks(0)   Quote maniva Quote  Post ReplyReply Direct Link To This Post Posted: 27 February 2003 at 12:46pm

Thanks Morninz,
but what is RSTIDENT ??

I've to define it ?

Bye
Ivano Mangiarotti
Back to Top
MorningZ View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MorningZ Quote  Post ReplyReply Direct Link To This Post Posted: 27 February 2003 at 12:52pm
its a new recordset object, thats all
Contribute to the working anarchy we fondly call the Internet
Back to Top
maniva View Drop Down
Groupie
Groupie
Avatar

Joined: 04 April 2002
Location: Italy
Status: Offline
Points: 82 		Post Options Post Options   Thanks (0) Thanks(0)   Quote maniva Quote  Post ReplyReply Direct Link To This Post Posted: 27 February 2003 at 12:56pm

Sorry Morninz but It doesn't work

Tipo di errore:
Errore di run-time di Microsoft VBScript (0x800A01A8)
Necessario oggetto: ''
/Artist/Opere_upload.asp, line 56

 
Ivano Mangiarotti
Back to Top
MorningZ View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MorningZ Quote  Post ReplyReply Direct Link To This Post Posted: 27 February 2003 at 1:05pm
dunno what to tell you, i pulled that little snip from some working code on my site...

which i originally got from this how-to
Contribute to the working anarchy we fondly call the Internet
Back to Top
MadDog View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 01 January 2002
Status: Offline
Points: 3008 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MadDog Quote  Post ReplyReply Direct Link To This Post Posted: 27 February 2003 at 1:52pm

keep it easy =P

If (strMode = "edit" OR strMode = "new") Then
 
  If strMode = "new" Then rsOpere.AddNew
   rsOpere.Fields("Author_id") = AutorId
  
   rsOpere.Update
    rsOpere.MoveLast

    AutorID = rsOpere("Author_id")
End If



Edited by MadDog
Back to Top
Bunce View Drop Down
Senior Member
Senior Member
Avatar

Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Bunce Quote  Post ReplyReply Direct Link To This Post Posted: 27 February 2003 at 6:52pm

Mornigz method is preffered, however you need to be using Jet 4.0 (Access 2000+)

Cheers,
Andrew
There have been many, many posts made throughout the world...
This was one of them.
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.