---Get next ID number
	DECLARE 
		@ID int
	
	IF (SELECT count(*) FROM @TableName ) > 0
		BEGIN
			SELECT @ID  = max(ColumnName ) from @TableName
			SET @ID = @ID + 1 
		END
	ELSE
	BEGIN
		SET @ID  = 1
	END

public class IdGenerator {
	
	private long maxId; 
	
	public IdGenerator(long start) {
		maxId = start;
	}
	
	public long getNextId () {
		return ++maxId;
	}

} // IdGenerator

# nnnn is the id to be checked
http://www.dopa.go.th/cgi-bin/inqelect.sh?pid=nnnn

import urllib, re
def getname(id):
  url = 'http://www.dopa.go.th/cgi-bin/inqelect.sh?pid=' + str(id)
  src = urllib.urlopen(url).read()
  pat = '<H3> *(.*?) *<'
  name = re.findall(pat, src)[0]  # don't use other info
  return name

print getname(5100900050063)  # show a name (one of my relatives)

# table schema
# CREATE TABLE person (id COUNTER, name VARCHAR)

db = e32db.Dbms()
db.begin()  # begin transaction (lock other inserts)
db.execute(u"INSERT INTO person(name) VALUES 'korakot' ") # insert a new row

dbv = e32db.Db_view()
dbv.prepare(db, u"SELECT id FROM person ORDER BY id DESC")
dbv.first_line()
dbv.get_line()
last_id = dbv.col(1)  # get it!

db.commit()  # commit the transaction