Search results for query: *

Ctr + < will delete records in list items

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 &quot;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!

In order to make data type consistent, we need to convert null to number or char depending on our specific circumstances. When I used &quot;to_number(null), null, to_number(null)&quot;, I got that error message, so I tried inserting 0 instead &quot;0, null, 0&quot;, that works, so I guess the...

thank you, turkbear, in fact, my code is as below, it doesn't work when I try to select any thing from it. I always got the error ORA-01790: expression must have same datatype as corresponding expression. It seems to_number() doesn't work in my case. ??? +++++++++++++++++++++ create or replace...

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...

Sorry, don't be mad at me, please. but I did read the whole thread several times. I did include rp_test.jsp under 'report' node in form. All my file name, report node name(object name?), report name are same as rp_test. I did try using both FIND_REPORT_OBJECT('C:\myFiles\rp_test')and...

I have the same code as above. DECLARE repid REPORT_OBJECT; v_rep VARCHAR2(100); rep_status VARCHAR2(20); BEGIN repid := FIND_REPORT_OBJECT('C:\myFiles\rp_test'); v_rep := RUN_REPORT_OBJECT(repid); END; I embeded this code in a button in a form, I can compile it, but when I deploy the...

I can check the form_status to see whether it's already been 'changed', and either doing nothing or throw my own customized alert accordingly, but it can't suppress the &quot;Do you want to save the changes&quot; fired by new_form(..). It's really anoying. Thank you for clarification. I am...

But how to pass non-default parameter (NO_VALIDATE, NO_COMMIT, NO_VALIDATE) to new_form()? I tried to used new_form('...', DO_COMMIT) and new_form('...', NO_COMMIT), but then I can't exit the current form any more.

I use new_form(...) to navigate between different forms, how to get rid of the message: &quot;Do you want to save the changes?&quot; 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...

Dima, thank you so much. But can you speak in detail? 1. I have created my customized menu. 2. add some new menu items to the above, set them as 'magic items', set 'icon in menu' and specify 'icon filename'? But I want to include smartbar in it. What's the path for smartbar or default menu? I...

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!