Hi, this sounds me very strange. I use sequences in PostgreSQL and with: 1. autoInc="true" in dbforms-config.xml 2. the default value setted in the SQL column as "nextval(sequence_name)" all runs well. The only strange behaviour is in insert mode.. when I insert a record dbform will re-position the cursor on the first record of the table (maybe because dbforms couldn't know the autogenerated id).
Another way I used is with interceptors. Creating a pre-insert interceptor I put in the filedvalues of the new record the generated id. In the interceptor body I put a call to the DBMS as nextval(sequence_name) and I get the new ID... the I put this value in the fieldValue of the field ID... finally I grant the operation to dbforms. In this case I haven't a autoInc="true" in dbforms-config.xml Hope this helps ivan Quoting kangi <[EMAIL PROTECTED]>: > hi all, > autoincrement doesn't work on the column based on the Oracle sequence > mechanism, is there any alternative way to solve the problem besides the > interceptor? > > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > DbForms Mailing List > > http://www.wap-force.net/dbforms > ------------ Ivan Codarin ============ ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_ide95&alloc_id396&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
