Delete Value from LOV after selecting it
This example illustrate how to remove a value from LOV after selecting it ( removing from the LOV not from the Database ) the point here is making restriction on values duplication in case we select the value again from the LOV that post his values on unique filed.
download the fmb file from this link :-
-------------------------
For more details , have a look for the codes :-
you must first to create this table on your Database:
CREATE GLOBAL TEMPORARY TABLE reg (
region_id NUMBER , region_name VARCHAR2(25)
) ON COMMIT DELETE ROWS;
and then do this in your Oracle Forms :
That's ALL , have a nice day.
download the fmb file from this link :-
For more details , have a look for the codes :-
you must first to create this table on your Database:
CREATE GLOBAL TEMPORARY TABLE reg (
region_id NUMBER , region_name VARCHAR2(25)
) ON COMMIT DELETE ROWS;
and then do this in your Oracle Forms :
That's ALL , have a nice day.
Posts
