i am populating 3 records in my data block.i do not want more than 3 rows.but when i click the plus icon in form menu one more row is getting generated which i do not want. i can restrict the new record addition through plus icon in menu bar for a particular block.
View 1 RepliesI want to create icon menu.
It fails to upload the images (newrec, saverec, delrec, etc) even the path is given in ICON_FILE_NAME.
My procedure proc_ex is in when_validate_item trigger
I have one Multi Record data block in my form with values in its items
I need to Populate multi record block values to one Record Group using
add_group_row,
add_group_column,
set_group_char_cell to populate values to record group
Let us suppose my multi record data block looks like
item1 item2 item3 item4
10 20 50 70
25 15 30 45
45 90 47 38
75 25 85 90
30 56 78 80
how to populate these multi record datablock values to Record Group ???..Eagerly waiting for your Replies
declare
cursor c1 is select distinct edt, regno, name, desgn, form_no, form_status, recd_on
from ol_registration_vu
where RECD_ON between :control.REC_FROM and :control.REC_TO ;
[Code]....
this coding giving me only one record i.e the last record of the table, whereas the table has 50 records. how can i get all records from the table in the form datablock.
i want to add icon in my form at run time and i m use PRE-FORM trigger
and i use this line for add icon
Win_Api_Session.Change_MDI_Icon(Win_Api_Utility.Get_Active_Window, '.IconsCompany.ico', Icon_Id); and these lines
MDI_ICO := WIN_API_UTILITY.GET_ACTIVE_WINDOW;
WIN_API_SESSION.CHANGE_MDI_ICON(MDI_ICO, '.IconsCompany.ico', 0);
i also attach the "d2kwutil.pll" library.but when i run form this error comes and my forms will be closed.
FRM-40734 : INTERNAL ERROR : PL/SQL ERROR OCCURRED
and my whole Code of PRE-FORM is this...
DECLARE
MDI_ICO PLS_INTEGER;
ONAME VARCHAR2(200);
Icon_Id PLS_INTEGER:=0;
BEGIN
[code]....
I want to create a Menu in my form .
First i create a form in Form Style using emp data block . Then , I create a Menu with two items . Then i compile and save both of them . But when i run my form , Menu does not appear .
i have one form name is LOV.fmb and i have one menu name is summit_menu.mmb how to display menu instead of default menu.
View 2 Replies View RelatedI have a data block with hundreds of records. I display data from the block on a tabular form. One of the items on a block is a "Employee Id". I also have a search button on a form. It lets the user enter "employee Id" and press the search to find the employee in a tabular list. Everything works just fine FIRST_RECORD and NEXT_RECORD commands do the job of finding. When the "Employee Id" is found I use Go_Item to focus on a found record. My question is how to make the found record to be the top/first item displayed in a tabular form. I spend two days searching forums for the answers. Unfortunately this is a user requirement and I must find a solution.
View 4 Replies View Relatedhow to get total number of record in form
View 3 Replies View RelatedI have a form reading record information from a flat file and inserting data into a number of varied tables. At the end of file (last line read) the form issues a commit to make all inserts/updates permanent.
There is a record that disappears in particular and this everytime I re-run the test. I mean than in Debug mode, I find it in the right table everytime I query that table until the moment the commit is issued in the code - which is definitely the opposite of what should happen. I understand that for some reason a rollback happens for that record (others are ok after the commit) but my point is that if for some constraint reasons, the record did not qualify, an error should have popped up right from the Insert that added that record, right? Then How comes I find it in the table up until the moment of the commit ?? ...is the deferrable constraint property a clue for digging further?
i have one multiple record field in frm....contain 5 field.....now i display the values...3 fields have values and two are empty...
the value of 1st field is A
2nd field is B
3rd field is C
i want if i click B it will open another form,
i want if i click c it will open another form,
I have one plsql table which is having 10,000 rows, i want to populate this values in a forms datablock, i have used the below query in pre-query of that block
declare
plsql_rec pkg.plsql_tab;
begin
plsql_rec := pkg.func;
set_block_property('blk_name', query_data_source_name, 'select e.ename, e.empno from table(plsql_rec) e');
end;
in the property of the block i set like below
Database Data Block = YES
Query Allowed = YES
Query Data Source Type = FROM clause query
Query Data Source Name = SELECT 1, 2 FROM DUAL
but while executing it says invalid identifier "plsql_rec",
MASTER-DETAIL FORM HAVING AN LOV IN THE MASTER .LOV SELECTS THE PRIMARY KEY FIELD FROM THE MASTER TABLE AND IN LOV PUSHBUTTON HAVING A TRIGGER WHEN BUTTON PRESSED
Declare
bool boolean;
begin
bool := show_LOV('PURCHASELOV');
[code]...
WHEN SELECTING THE ITEM THROUGH LOV IT EXECUTES ALL VALUES BUT AFTER CHANGING ANY DATAS THEN NEW RECORD IS CREATED IN THE MASTER TABLE AND NO CHANGES OCCURED TO THE CHANGED RECORD.
How do you refresh a datablock after DML operation(s) - INSERT, UPDATE or DELETE? I know "EXECUTE_QUERY" retrieves records, but what trigger do I use to automatically refresh the datablock after these operations - my form only has 1 datablock.
View 3 Replies View Relatedi want to decode a column(aan_status) of a datablock based on table. the column have value in the form of 0 and 1, and i want to display this value as yes(0) or no(1) on my oracle form. how can i do this and where should i put my code???
i tried this by
set_block_property('aan_occupant_vu', DEFAULT_WHERE, qry1);
go_block('aan_occupant_vu');
clear_block(no_validate);
SYNCHRONIZE;
execute_query;
[Code]...
but if else part of my code is not working, as i got the data still in 0 and 1 format, not in 'YES' or 'NO' format.
I am developing an application for making the travel entries for my organization employees.
For that purpose I have 3 datablocks named:
1) Travel header
2) Employee Detail
3) Travel Detail
which are interlinked through constraints.
I want to give 2 options ie. either single booking entry or Group booking entry.
The form is working properly for single booking entry. But when I want to make a group booking wherein many employees have to travel between common locations I have to fill all the travel details again for all employees. I want to avoid that since it wont give a feasibility for this application. I can copy the travel details I have entered for the 1st employee. I am uploading the form layout.
I am developing form, but there is issue when I Press F11 to query data.I make trigger form when-new-record-instance to assign values for item.But when i Press F11 then Block no clear.
View 1 Replies View RelatedI have a list box from which the user can select a client's name, I want them to be able to press a button next to the box which will then open another form and display all the client's details. How do I attach a button to a list box? and how can I call another form to open on a specific record?
View 3 Replies View RelatedI've got a problem with binding my selected data from one data block to another. When I'd finished selecting my data(subjects in this case),
and I clicked schedule button, my selected data were not bound into the textboxes in schedule datablock.this what happened.the code i used in when-checkbox-changed trigger:
BEGIN
IF :NEWSTUDENTS.cb_subj = 'N' THEN
Clear_record;
ELSIF :NEWSTUDENTS.cb_subj = 'Y' THEN
:SCHEDULE2.Subject := :newstudents.subject_code;
END IF;
END;
and in tree-node-activated trigger:
MEssage('FOR LOOP - subj_code = ' || subj_rec.subject_code);
:NEWSTUDENTS.subject_code := label_of_mynode;
:NEWSTUDENTS.subject_= subj_rec.subject_code;
:NEWSTUDENTS.units:= subj_rec.units;
MESSAGE('POSITION OF CURSOR ' || :SYSTEM.CURSOR_RECORD);
[code]....
I have designed a form in which there are two datablocks one contains the major details and the other contains details saved under that record. And it is working properly. If you are not getting then take an example of department and employee datablocks, first contains the info of department and second contains the employee info working in that department.
now what i want to do is to make the life of user easier, as the records are displaying properly so if user want to know that this record is present in the details of that header so while scrolling all records can he search by putting some info in the detail block to get that result while remaining on the same datablock?
We are migrating oracle froms from 4.5 to 6i both based on window and character mode.
We have successfully migrated all the form to 6i on Linux and it is running fine.
The problem is that the menus were setup with a Menu Style of "Full Screen" in 4.5. But when run in 6i, the menu's are displayed as a single row across the top of the screen.
Client is bit rigid to retain their menu style in character mode after migration to 6i without going for Web solution.
I want to know, whether we can achive the full screen menu at all or not in 6i and if we can achieve then how?
I am using Developer 6i and i want to know how to replace the default icon in form window title bar with company's logo.
View 1 Replies View Relatedi want to set the icon on my forms i write these lines.... for to do this...
MDI_ICO := WIN_API_UTILITY.GET_ACTIVE_WINDOW;
WIN_API_SESSION.CHANGE_MDI_ICON(MDI_ICO, '.IconsCOMPANY.ico', 0);
and i also attached the library d2kwutil.pll and when i run the form then this error raised...
FRM-40734: Internal Error : PL/SQL error occurred..
now what can i do for set the icon at run time..the first part of the message has been removed as it belongs to @allianz2010's previous topic; the rest has been split into a new.
I developed a form in forms9i, at the time of data entering form is not showing any ERROR messages or SAVE RECORD message and when I press exit button it is asking "DO YOU WANT TO SAVE THE CHANGES YOU HAVE MADE".
I have checked my PRIMARY KEY field and there is no mistake and value is populating at PRE INSERT.
I already have and use .gif files for icons on various buttons in my forms. I need to use a different .gif file to create a new icon. When I enter the file name of the new .gif is not displayed on the button. If I reference an old and working .gif. The .gif appears on the button. What rules if any, must I observe when creating/using .gif files as icons for buttons?
Does the .gif file have to be of a special type? If so, what will I need to do?
Tree node icons. I created a table named TEMP_USER_MENU and contains the following structure
USER_IDVARCHAR2(15)N
MENU_IDNUMBER(15)N
MENU_DESCVARCHAR2(150)N
FILE_NAMEVARCHAR2(100)N
[code]...
Now all i wanted is to change each node icon. This query just make the parent nodes icon to OPEN folder like icon and the leaf node to FILE. You can see the decode query up there. It just chose the icons from the File_Name field when it founds 0 then it shows it's a parent node it makes it icon to OPEN else it make it to NEW.
Fist thing i want to know that from where the form builder is fetching these icons? i.e. from which path and what format it looks like a .png file ? .ico or a .jpeg file. I have searched a lot online but all in vain.
Second thing if i want to add unique icons in my menu tree on each node. Is there any possibility ? if yes. Then where should i keep my icons files and in which format?
I get below error when i tried to add the master site to the master definition site.
SQL> BEGIN
2 DBMS_REPCAT.ADD_MASTER_DATABASE(
3 gname => 'TEST',
4 master=> 'testdb2',
5 use_existing_objects => FALSE,
6 copy_rows => FALSE,
[code].......
Is it possible to perform any operation using oracle like addition and division in csv file before loading data in oracle. and after the operation changes must save.
Is it possible or not.
I cann't commit form when new instance form with form status is "NEW".
And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"
And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.
I am working on oracle 10g forms.my menu is so long and I want to add a vertical scroll bar to my menu .
View 6 Replies View Related