I want to create dynamic Lov. How can I create it? For practice I create a LOV at design time
RECORD_GROUP_QUERY value:
SELECT * FROM
EMP.
THEN I write some code in WHEN-BUTTON-PRESSED Trigger to replace RECORD_GROUP_QUERY at run time. Code is:
........
v_rg_id:=CREATE_GROUP_FROM_QUERY('TEST','SELECT * FROM DEPT');
........
After this I found a error at run time which is FRM-41826: Cannot replace group; columns don't match LOV.
I have a select box with products, and a dynamic action that updates a display only element with the price, based on the product selection.After the selection is made and the page is submitted, I have noticed that the price is not stored in the database. If I change the display only value to a text box, the data is saved. Is this expected behavior? If so, can I add something to the text box to make it not editable?
Version is Application Express 4.1.1.00.23
I am using Oracle Form 6i. I have created pdf file from oracle report. On view button, I have written:
host('C:Program FilesAdobeReader 8.0ReaderAcroRd32.exe C:dailypending.pdf');
I don't want to set this path on every machine. I want to set its dynamic path so that on which even I machine, I run the applicaiton, it will directly find AcroRd32.exe from any drive either C: or D: or anything else...
It might be Acrobat Reader 9.0 or 8.0 whatever version will be installed on client machine...I want to set path according to that..So that whatever version it would be, it doesnt affect the application..
I want to create a Dynamic record group and associate it to a LOV.for example: I want that for a set of people A, i want to fire the query in lov:
select * from emp where (condition 1)
and for another set of people B, I want to fire
select * from emp where (condition 2)...
How could I achieve it?
I have one requirement.I am populating LOV dynamically for the subinventory field in the order form through custom.pll.
If Dropship flag= 'Y' then populate suninv LOV with D1,d2..values.If it is 'N' then populate suninv LOV with w01,w02,....values.This is done and working fine in the form.But If i save dropship flag='Y' and Subinv value is D1 then it saves the record.Now I am changing Drop ship flag as 'N' then 'D1' value appearing in the SUBINV field.and it allow the save changes.
So How can i refresh Lov at the time of making drop ship flag as 'Y'/'N'?
how to create dynamic list item ????
View 5 Replies View Relatedi want to get user (dba roles in combo box runt time).i have write down this code in when new form instance.
declare
rg_id recordgroup := find_group('RG') ;
ln_error number ;
begin
if not id_null(rg_id) then
ln_error := populate_group(rg_id) ;
if ln_error = 0 then
populate_list('BLOCK3.T' , rg_id) ;
else
message('Error in Populating Group') ;
end if ;
end if ;
end ;
attached file.when i run it gives the follwoing error. frm-41334-invalid record group.
record group query is: SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE='MTSYS'
I'm still trying to import some video in my form.
So far I made one OLE container and add Oracle Video Control, then I made one button and wrote this trigger:
WHEN-BUTTON-PRESSED
declare
video_obj ole2.obj_type;
begin
video_obj := forms_ole.get_interface_pointer
(`MY_VIDEO');ole2.invoke(video_obj,`ImportFileAs');
end;
This works fine. All I want to do now and I don't know why (because I am quite new in Oracle development) is, to make one trigger that will choose automaticly wich video to play and if it is possible to make when I start the form automaticaly to start that video, if not, it's enough just to choose video automaticaly when I press the button.
i have a question regarding dynamic record group creation.I have a text item(department) attached with LOV ,and a list item is also there.i want whatever the department name i will select from ma LOV according to that corresponding manager name should be display in the list item.
my table structure is :-
table- QRY
column- DEPT_ID,DEPT_NAME,MANAGER_NAME
I am working on Forms 6i. I have data block A on table EMP.
Datablock A: Empno, Ename, Hiredate
I have FIND Screen: EMPNO, HIREDATE_FM,HIREDATE_TO and FIND Button.
I will search the records through FIND Screen.
I want to set the where condition of block A in pre-query trigger.
set_block_property('BLOCKA',default_where,'HIRE_DATE BETWEEN FIND.HIREDATE_FM and FIND.HIREDATE_TO');
Note: FIND in above is FIND Screen block.
It's not fetching any records, i doubt that there is syntax error in above statement.
I want to create two list items. one is for deptno and another is for empno in a single form.
Based on the selected deptno value from first list item i want to populate corresponding empno from second list item. I tried with the fallowing code, it's work fine but the second list is not clears with the existing empno's.
Code for Deptno List item
declare
cursor c is select deptno from dept;
cnt number := 1;
begin
clear_list('LI_DEPTNO');
[Code]...
Code for Empno list item in when_list_changed trigger for deptno list item
declare
cursor c is select empno from emp where deptno = :LI_DEPTNO;
cnt number := 1;
begin
it_id := Find_Item('LI_EMPNO');
clear_list(it_id);
for i in c loop
add_list_element('LI_EMPNO',cnt,i.empno,i.empno);
cnt := cnt + 1;
end loop;
end;
Here is good code and tips to run Dynamic Report from Oracle Forms 6i This utility uses tables and Views to design dynamic report. Just download zip file and unzip all files in a filder. Create database procedure attached, comile the form and use this.
View 3 Replies View RelatedHow could the lov restrict its list as the user types in values:
List:
Amanda
Leila
Leon
User types 'L'
List
Leila
Leon
User type
L+e
List
Leila
At the moment it works but the user has to click the button each time.
I have used a dynamic cursor for fetching value from different tables hence table name assigned dynamically during run time but i face an error ORA-06562 type of argument must match type of column and bind variable with error ORA-06212 But i frequently check the table structure and Declared variable there is no mismatch between them.
Code----------
Declare
C_YEAR number(38);
C_LOC VARCHAR2(200);
C_INVNO VARCHAR2(200);
C_INVDT DATE;
C_CTRT VARCHAR2(200);
C_GLCD VARCHAR2(200);
[code]....
create a table in forms .
i tried to do it with forms_table(--) but i am in confusion.
is there a way to keep the display of the form when we call another new form. my scenario will be as following:
am in form1 , i call form 2 from a menu, after this call form2 is open in place of form1.
i have no control in form1 and i can't change anything on it, i don't know hw the menu option is calling form2.the only control i have will be within form2 if there is any change i can make it.i read something about MDI, and OPEN_FORM() procedure, but i think this will required a change in form1 which i can't do.
is there any change i can make in form2 to display it and keep the display of form1 at the same time behind it ?
I would like to display PDFs in Oracle Forms. The PDFs are stored in an Oracle 10g database.
View 2 Replies View RelatedIm facing some issues with my form, getting stuck... prob desc below : I have Table A which has columns; car_year, car_type, line_num, line_text. Table B has country, car_year, car_type, line_num, data_entry_amt.
Table A contains data which gets updated once every year only. Contains what year model is the car, what type of car it is.. Line_num has numbers starting from 1 which indicates the different part number and line_text has description for that line_num. eg :
2010 Toyota 1 Windshield
2010 Toyota 2 Door
2010 Toyota 3 Tire
2010 BMW 1 Windshield
2010 BMW 2 Door
2010 BMW 3 Tire
2010 BMW 4 Rear_mirror
Table B contains specific data related to table A, Contains country where car details n prices are, car_year, car_type, line_num, and amount($) for that part. for example :
Australia 2010 Toyota 1 400.50
Australia 2010 Toyota 2 200.40
Australia 2010 Toyota 3 308.25
So in year 2010, in Australia, Toyota's Door was sold at $200.40 Now, Table A will have similar data for this year and users will enter data for table B throughout this year. I tried master-detail form for this but it doesnt work. Because every year line_num change in table A and therefore cant implement a fixed number or rows on the form for amount for table B.
How to use dynamic listing but im not familiar with it. So how i should go about doing this. My form has structure has below :
Country Car_year
___________________________________________________
table_A.line_num table_A.line_text table_B.data_entry_amt
table_A.line_num table_A.line_text table_B.data_entry_amt
table_A.line_num table_A.line_text table_B.data_entry_amt
table_A.line_num table_A.line_text table_B.data_entry_amt
When clicked on save, data on table_B.data_entry_amt on this form should go n insert into table B.
i want to create a form & show some columns accordingly rows entered in another table
for eg.
a table name temp have three columns (no,name,date) in name it shows some rows like
a
b
c
d
i want to create a new dummy form which shows
a b c d
if i remove b from temp table then new form shows only
a c d
is it possible
i have created a small table which contains only name of cities.On form level i want to create a dynamic list of the name of these cities just by clicking on the textbox without doing any hardcoding.
View 25 Replies View RelatedFor passing my apprenticeship I am developing part of an application to change the language of the application dynamically.
My first idea looks like this:
In each form I add a package that works like this:
block := first block
loop
..item := first item
..loop
....set item label or prompt to new language
....exit when item = last item
....item := next item
..end loop
..exit when block = last block
..block := next block
end loop
That far everything is fine. With the get_form_property I can access the first and last block and always get the next block with the get_block_property. Same is true for the items by get_block_property for the first and last item and the get_item_property for the next item. By this way I can dynamically chance all item prompts and labels without knowing the name or the number of blocks and items. But what about radio groups? Is there any possibility (and if yes, which?) to get the first, last and next radio button of a radio group in the same way?
I'm using forms 9i. Let's say I have a Block in the form B1. It has two items I1 and I2. I have a table called T1 that has a column say C1. The data in the only record in T1 is 'NAME_IN(''B1.I1'') = 1 OR NAME_IN(''B1.I2'') = 2'..In forms I need to execute the following at POST-QUERY trigger of the block:-
DECLARE
VAR1 VARCHAR2(1000);
BEGIN
SELECT C1
INTO VAR1
FROM T1;
[code]....
As you could see that the IF statement is wrong. But I get the condition (for IF condition) as a string value from some database table.
I have text item and it is assigned with lov namely 'Typelov' and that xlov assigned with 'Rgtype'. When I create the record group i just create with sql
like
select distinct type from x;
But at runtime i want to change the query
select distinct type from x where col1 = 'XXX';
and now the lov should display the above filtter condition item only.Is there any possible
How can i use this below example in forms builder 10gr2
var oput_cur refcursor
var tabname varchar2(30)
exec :tab_name := 'dual';
begin
open :oput_cur for 'select * from ' || :tabname;
end;
/
print oput_cur
how can i get the values from oput_cur into forms grids(containing text items).
I have 2 tables T1, T2
T1 is having 2 columns t1_c1, t1_c2
T2 is having 3 columns t2_c1,t2_c2,t2_c3
I need to design a form which should be like
there must be a pop item (Dropdown menu) in a separate block.
If I select 1 from the pop item,
T1 with 2 columns should display in a tabular form.
If I select 2 from the pop item,
T2 with 3 columns should display and T1 with 2 columns should hide.
So the form should be dynamic based on the selected pop item. Is there any chance to do this?
I want to display a specified image if not form_success!
declare
image_path varchar2(80) := 'C:R_ORACLEPHOTOS';
photo_name varchar2(80);
begin
:system.message_level := '25';
[code].......
My form failed to display photo (data type long row).
scenario a)
If photo in black and white with
width : 472 pixels
height: 590 pixels
horizontal resolution : 300dpi
vertical resolution : 300dpi
bit depth : 8
size file : 28KB
scenario b)
If photo in color with
width : 124 pixels
height: 155 pixels
horizontal resolution : 75dpi
vertical resolution : 75dpi
bit depth : 24
size file : 14KB
Above 2 scenario:
My form 6 program can successful display the photo for scenario a , while for scenario b, my form 6 program failed to display the photo.
I have a form in which the fields are not database items i want to display the next record, i know i can use the next_record for the same but it does not work since it is not the database item, is there any way when the item is not the database item and i can see the next record. I use the cursor for loop but since it fecthes all the records in one go it cannot display one record at the time in the form..
View 3 Replies View RelatedHow do I display map on the oracle forms using mapviewer?
View 1 Replies View RelatedIn alters I want to display a value dynamically.
like when deptno=10 came then it should dynamically displays the message like Department 10''.
when deptno=20 came then it should dynamically displays the message like Department 20''. and.....