> > <field name="MAX(number) as number" fieldType="smallint" size="6" > isKey="true" autoInc="true"/> > > and used > <db:dbform... whereClause="where name = 'test' group by name"...> > > But well that makes it impossible for the user to then adjust > the data if > necessary. Oh well back to stuffing things in the session to > filter by > (and needing an extra query to look up the index). No change because dbforms do not know anything about the new inserted value - remember it must'nt be maximum of the number.
I handle this problem by not using autoInc - i just use the preInsert interceptor to add retrieve a new key index from the database and insert this into the resultset. Then dbforms knows the new index an can jump to the new record. Regards, Henner ------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
