Insert-Retrieve Autonumber in Ms Access using JSP

sriram225's Avatar, Join Date: May 2009
Go4Expert Member
My Db SChema...
Quote:
ser_no : AUTONUMBER
name : TEXT

When i Insert a record how can i write my query ???
insert into table_name (ser_no,name) values('','jagadesh');
but this is not working....and after inserting succesfully i have to print AUTONUMBER (Retrieving) for correspoding record inserted !!??

Any Help Would be Greatly Appreciated Thank You!!!!
0
gkumar's Avatar
Banned
Please cut out that excessive use of dots, exclamation, question marks and Advertisement Like Words. You now look like an annoying little yelling child. Please don't do that. Please come over as a professional, try to ask questions the smart way.

With regard to your problem, use Statement#getGeneratedKeys().