• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

piece of code for auto generation of numbers

 
narayana satish
Greenhorn
Posts: 25
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am doing a project in which i am using SQL as back end. I want to write a piece of code which will make autogeneration for the field PA_NO whenever if i add the record to back end.
 
Art Metzer
Ranch Hand
Posts: 241
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, Narayana.
If you have no objection to sequentially assigned prime keys (1, 2, 3, etc.), then simply do a SELECT MAX() against your database table's prime key. If nothing is returned (i.e., that table has no rows), set the prime key to 1. If you get a value back from SELECT MAX(), add 1 to it to generate your next prime key.
Of course, to prevent prime key duplication (a BIG no-no), you'll have to make these processes synchronized.
Good luck, and I hope this helps,
Art
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic