[sriram225]

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!!!!

[gkumar]

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().