hello all, because autoInc feature doesnt work for oracle database i wrote trigger to implement sequence in my application which will be fired when there will be value coming from overridevalue attribute of textfield (in my case -99)
eg) <db:textField size="" fieldName="STAT_CD" style="font-family: GJW- TTKrishna;" hidden = "true" overrideValue = "-99" /> and the trigger is create or replace trigger t_seq_kmtalkm1 after insert on kmtalkm1 begin update kmtalkm1 set talk_cd=seq_kmtalkm1.nextval where talk_cd = -99; end; but now the problem is when i update the values then also databse value changes to -99 but i dont want that since it is a primary key in my case so how do i avoid this any suggestions........... and if autoInc feature works with oracle then i will be extremely thankful if anybody can show me how?? thank u abhi . http://intranet.da-iict.org ------------------------------------------------------- This SF.net email is sponsored by: The Definitive IT and Networking Event. Be There! NetWorld+Interop Las Vegas 2003 -- Register today! http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
