I tried to code nothing in on-update, and hoping this will override the built-in update function. But there is no update sign as insert or delete sign. So everytime, when I change sth, then I have to click save, I got error "frm-40501: oracle error: unable to reserve record for update or...
I am using forms9i, the [x] sign on the corner of the screen seems need some code to work. I put hide_window('win_name') under when_window_closed trigger, but it doesn't work. Which trigger is associated with [X]?
Thank you!
When I do the union like this, it works,
select a, b, c
from A
union
select d, e, to_number(NULL)
from B;
But when I put it inside a view:
create or replace view XXX AS
(select a, b, c
from A
union
select d, e, to_number(NULL)
from B; )
The view can be created, but when I did any...
I use new_form(...) to navigate between different forms, how to get rid of the message: "Do you want to save the changes?" I wrote my own alert at each navigation button in each form, but I still couldn't get ride of the un-desired message. I set system message level to 25, but it...
I created my customized menu, and attached it to the form, but I also want to keep the smart bar for insert, update and delete, etc. I tried a long time, but it seems I can either have my own menu or default+smartBar menu. How to have customized menu plus smart bar menu?
thank you very much!
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.