السلام عليكم


How can i test with the help of the function NVL in when-validate-item
that the field must be unique

ربنا يكرمكم

I have a when-validate-item firing on an item that the user has not to enter a value for. The item must be unique. How can i test it?
so the item may be null but must be unique, any idea

Thanks for your Help!!![/size]

set a unique constraint on the column in the database
or
set the property of the item in the form to "uniuqe" to be "YES".

Jazaki allahou kayran.
I want to make this property in runtime so not in design and not with a constraint.

Sorry I was confused there's no such property in the form
but you have to do it programatically
try this one
--------------------
declare
v_cnt number;
begin
begin
select count(*)
into v_cnt
from SALGRADE
where grade = :grade;
exception
when others then null;
end;
if v_cnt > 0 then
raise form_trigger_failure;
end if;
end;
-------------------
but for this solution you will need to save each record

replace the "salgrad" table with you table and "grade" with your column