Welcome to Aspire Knowledge Central (AKC)

   Home   Public Library   Author Content

Choose a data format:   classic-xml   object-xml   embedded-xml   text   excel

---

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