I want the next value of my sequence to be display in the item only when am try to insert new record i wrot this code in


WHEN-NEW-RECORD-INSTANCE

select EMP_SVC.nextval
into :ADMEMPL010.ADMEMPL_SVC_NO_PK
from dual;

but when am runing the form and befor query the form record the next sequence value will display and i dont want this i want the next value to be display only when i press ADD
button to add new record to the table

Dear Sister
put your code in the pre-insert trigger

PRE-INSERT TRIGGER is more better than WHEN-NEW-RECORD-INSTANCE,
because you may try to add new record but u roll back then the sequence will fire its nextval, and it may cause a GAP in ur field sequence.

تم تعديل 28 أغسطس 200718 سنة بواسطة MoHaNnEd

i tryed to write it in pre-insert of the block level
but when i run the form and press ADD button the sequnce next value did show