How to display S.no adjacent to employees table help plsss
610795Mar 20 2008 — edited Mar 24 2008In a form in tabular format Emp details are displayed
Adjacent to the table i want to put a Sno display item showing
1 for 1st employee
2 for 2nd employee ......
I thought i could like create a global variable in a package specification in a program unit and assign it to 1
Package pack1 is
v_num number :=1;
end;
and then write a PRE_ITEM trigger for a Sno item in the object navigator
In the trigger
how to display the value inside v_cnt;
I tried creating a sequence
create sequence v_seq;
but the sequence really wont help me as
it would keep on incrementing
so how can i display the value inside the v_cnt in a item
Is it possible not to use a trigger and still achieve this