18-Aug-03 (Created: 18-Aug-03) | More in 'Howto'

How to get autonumbers for inserts in Access?

Try the following 

request.doinsert.classname=com.ai.db.DBPreTranslateArgsMultiRequestExectuor
request.doinsert.db=yourdb
request.doinsert.query_type=update
request.doinsert.request.1=INS-1
request.doinsert.request.2=GETKEY
request.doinsert.request.3=INS-2

#INS-1
request.INS-1.classname=com.ai.db.DBRequestExecutor2
request.INS-1.db=yourdb
request.INS-1.query_type=update
request.INS-1.stmt=your-insert-statemnt

#INS-1
request.INS-1.classname=com.ai.db.DBRequestExecutor2
request.INS-1.db=yourdb
request.INS-1.stmt=\
select @@identity as my_key


#INS-2
request.INS-2.classname=com.ai.db.DBRequestExecutor2
request.INS-2.db=yourdb
request.INS-2.query_type=update
request.INS-2.stmt=your-insert-statemnt with my_key as one of its args

Satya