Hi, I'm using the "selectKey" with insert commands. It works great. We are using a development database based in SQLite, and the select is like this: select max(id)+1 from TABLE Now, we are moving our project to the production enviroment, a Oracle 10g database, and in this scenario we'll use a sequence: Select theSequence.nextval from dual
The problem: in each scenario, the selectKey statement must be different. How can I avoid this, or minimize? Thanks in advance