Hi,
I am forms 6i user
If my understanding is correct what u r asking is u don't want to validate the fields then and there. You want to do the validation just b4 u save and prompt the user to enter the field.
U can remove the NULL validation in the item level and in the item level u can use...
Hi,
U try to create before update trigger like this
create trigger bef_upd before update on <table_name>
for each row
begin
:new.db_user := user;
:new.updated_time := SYSDATE;
end;
hope this helps
mahesh
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.