hi all,
i am using Forms [32 Bit] Version 6.0.8.24.1 (Production).
i am calculating serial as below
and assigning it to the record in the pre-insert trigger
the code is as below.
pre-insert trigger
cursor c_serial is
select nvl(max(pp_serial),0) + 1
from purchase_order
where pp_order = :pp_order
and pp_po_order = :pp_po_order;
open c_serial;
fetch c_serial into :pp_serial;
close c_serial;
its just working perfect but the problem is the serials is not visible until and unless the records have been saved(since the code is written in pre-insert trigger)
how can i show this serial on the screen when user leaves that record?
can i use post built-in? in which trigger i can post the data?
my aim is to take the serial as i mentioned and make it visible to the user when he leaves the record itself?
Please help..
Thanks..
Edited by: GD on May 2, 2011 2:50 AM