I have a form with an index (called "number") that is automatically filled by the database.
After entering a new record, I want to navigate to that record. but currently there seems no way to do that.
Oops actually there is... I just made and alias of my table and included all the fields with the index redefined to be:
<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).
--
Shawn
Happily using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
------------------------------------------------------- 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
