The Artima Developer Community
Articles | News | Weblogs | Books | Forums
Artima Forums | Articles | Weblogs | Java Answers | News
Sponsored Link •

Java Answers Forum
Last record / Autovalue

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
Matthias Neumair

Posts: 660
Nickname: neumi
Registered: Sep, 2003

Last record / Autovalue Posted: Jun 13, 2005 12:16 AM
Reply to this message Reply
Advertisement
I'm using a JDBC / ADO Bridge to access a MS Access Database.
Everything works fine so far.

Most of the tables use a auto generated long value as index.

Is there a way to get the index of the last inserted row/record?

At the moment before saving I read in all keys, insert the new row, then I compare the old and the new key list to get the new key (using a "not in (...)" sql statement).

Is there any better way to do it?

Topic: Mail Fetching Previous Topic   Next Topic Topic: Javatoolbox
Sponsored Links


Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use