Recent content by munee

java restricts on calling parameter form on web. so you cannot invoke parameter form when you call a report from forms on the web. The workaround for this is to pass parameter from forms to reports. You can create a form which looks like a parameter form, create text_items in which users can...

'FMDD MON, YYYY' But it will show 01 JAN, 2000 I do not know how to just show 1 JAN,2000.

Use the alert option. DECLARE rc NUMBER; BEGIN IF :System.Mode = 'ENTER-QUERY' THEN set_alert_property('ALERT_QUERY', alert_message_text, 'You are in Enter Query Mode') ; rc := show_alert('ALERT_FAIL'); END;

CHR(10)

Thanks Sem.

Hi All, I want to select a file from local hard disk on oracle forms (web based). This is similar to we have in word when we hit open button. After that I need to do update based on employee numbers based in that file. Has somebody already done such a form. Or Atleast some idea/command will...

I resolved this. Thanks for help sem.

Thanks Sem. This is a requirement that Date should appear with all records and hence I can not break on group. Do we have any other solution.

No I want to do it without using break group. As the user do not want to break it based on date.

Hi, I have a report. One column is date. The report shows number of records modifed for that date along with n number of other information. I want that when this date changes A BLANK LINE should appear in the report. The will make it easy to distinguish. I have no idea how to code for it. Can...

Hi All, I have created a form on a table. The table has a primary key. On KEY-COMMIT on form level, I have written my own insert statement to insert record instead of using default commit. I get constraint error (unique constraint violated). I removed the Primary key and noticed that two...

Hi Sem, This package is useful for 8.1.7 version onwards only. That is why I thought to have some cutomised logic. Thanks for ur help.

Hi, I want to create a login screen but want to encrypt the password before storing in oracle table. Does somebody has already written simple logic for this encryption and decryption. I am using Oracle developer forms for creating login screen. Thanks Muni