-
Data which are checked in control block should be populated in detailed block
hello,i am facing one problem. I have one main form. In that when i press one button, one window will be pop up with the details of Orders for the particular supplier which was selected in main form. I will check only few orders which i need and when ever i click submit, those checked records should populate in the detailed grid. Popup window is based on control block.One record it is populating. But...
V12345
- Oct 14th, 2008
Try moving the pointer in the detailed block to NEXT_RECORD after you populate each record
samrat_misra
- Aug 14th, 2008
First go to the first record of that block from which you want to populate data, check whether that is checked or not, if checked then assigned those values into that block where you want to poulate. Loop untill the last record is fetched. May be it can resolve your problem
-
What is Post-Block is a . a. Navigational Trigger. b. Key trigger c. Transaction Trigger. Navigational Trigger.
mukts
- Mar 31st, 2006
Navigational Trigger.
-
How do you control the constraints in forms ?
Select the use constraint property is ON Block definition screen. BLOCK
i.govardhan
- Sep 18th, 2008
We control the constraints in forms while selecting primary key 'yes' in property palett.
parash_3380
- May 4th, 2006
Hi,we control the constraints in forms while selecting primary key 'YES' in property palette.
-
What are the type of User Exits ?
ORACLE Precompliers user exitsOCI (ORACLE Call Interface)Non-ORACEL user exits. Page :
sumanpani
- Sep 16th, 2008
You can write the following types of user exits: ORACLE Precompiler user exits OCI (ORACLE Call Interface) user exits Non-ORACLE user exits User exits can perform the following tasks: ...
-
What are User Exits ?
sumanpani
- Sep 16th, 2008
A user exit is a program that you write and then link into the Report Builder executable or user exit DLL files. You build user exits when you want to pass control from Report Builder to a program you have written, which performs some function, and then returns control to Report Builder.
Devi Prasad Mishra
- Sep 30th, 2005
User Exits is a program which is used to pass the control from the Report Builder to a third generation language for performing complex calculations and returning the value back to the Report Builder.
-
Hi,what is place holder column?where we can use other than formula column?
sumanpani
- Sep 16th, 2008
A placeholder is a column for which you set the datatype and value in PL/SQL that you define. You can set the value of a placeholder column in the following places: n the Before Report Trig...
rampratap409
- Dec 6th, 2006
Place holder column is the name of variable which can hold a calculated value like ( sum, avg..) or the value can be set by function or by a pl/sql block.use of place holder column for aggrigate function is not advised, for that use summary column.
-
How will you create a formula or a summary column and refer it other fields
renukuntanagaraj
- Sep 10th, 2008
1. Open data model editor, increase the height of the group to make place for the formula column or summary column.2. Select the formula column tool button in the tool palette and place it after the l...
-
What are the different types of key triggers ?
Function Key Key-function Key-others Key-startup
-
System _Generate Number
how can you generate the system _generate number in forms automaticallyhint: IN FORMS WE CREATING ONE DATA BLOCK BUT ONE CLOUMN (EMPLOYEE_ID) THIS COLUMN GENERATE THE ID NUMBER AUTOMATICALLY WITH OUT CREATING SEQUNENCE
usmanahmad
- Aug 18th, 2008
1: EMPLOYEE_ID := DBMS_RANDOM.STRING('X',6); ---- its generates unique EMPLOYEE_ID six char long 2: Then check whether newly generated id is already in DB. Create a cursor which select and return ids ...
-
Can a value for a display item come from two blocks? How will that be done?
table12345
- Aug 1st, 2008
Yes it can come from two blocks. If the cource block is database/from clause?query?block then just go to the POST-QUERY of that block where display item exist and write :block.display_item:=block1.field1||block.field2 int hat POST-QUERY.
-
What are the triggers associated with master detail relationships ?
Ziaullah
- Jul 18th, 2008
NON-ISOLATED (default) a) on check delete masterb) on clear detailsc) on populate details ISOLATEDa) on clear detailsb) on populate detailsCASCADE a) per-deleteb) on clear detailsc) on populate details
Neethi
- Jan 17th, 2007
* Non-Isolated (default)On-Check delete MasterOn Populate DetailsOn Clear Details*IsolatedOn Clear DetailsOn Populate Details*CascadePer-DeleteOn Clear detailsOn Populate Details
-
Can we use GO-BLOCK package in a pre-field trigger ?
No.
-
What are the built_in used to trapping errors in forms 4?
Error_type return character Error_code return number Error_text return char Dbms_error_code return no. Dbms_error_text return char
sandeep5580
- Mar 29th, 2008
Well i am not pretty sure about this. I think we can use sqlerrm to trap an error.Thanks.Sandeep
-
What are the types of TRIGGERS ?
1. Navigational Triggers. 2. Transaction Triggers.
kishor s pawar
- Mar 17th, 2008
Pre triggers,post triggers,when trigger,transactional trigger,validation triggers,key triggerskishor
anilkln
- Feb 21st, 2008
actually there r 3 levels of triggers1)formlevel 2)block level 3) item leveland types of triggers r1 activex triggers2 block processing triggers3 interface event triggers4 key triggers5mas...
-
What is a predefined exception available in forms 4.0?
Raise form_trigger_failure
g_sidhu
- Feb 15th, 2008
Raising the FORM_TRIGGER_FAILURE Exception: The FORM_TRIGGER_FAILURE exception is a predefined PL/SQL exception available only in Oracle Forms. Because it is predefined, you can raise this exception w...
-
List some built-in routines used to manipulate images in image_item?
Image_add Image_and Image_subtract Image_xor Image_zoom
g_sidhu
- Feb 15th, 2008
Image_addImage_andImage_subtractImage_xorIMAGE_ZOOM: Zooms the image in or out using the effect specified in zoom_type and the amount specified in zoom_factor.IMAGE_SCROLL: Scrolls the image item as c...
-
What is a library in Forms 4.0?
A library is a collection of Pl/SQL program units, including user named procedures, functions & packages
g_sidhu
- Feb 14th, 2008
A library is a collection of subprograms, including user-named procedures, functions, and packages. Libraries provide a convenient means of storing client-side program units and sharing them among mul...
-
What is a record Group?
A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table
g_sidhu
- Feb 14th, 2008
All LOVs are based on another Forms object called a record group. Record groups are logical objects, so they have no physical properties and are never displayed to the user. A record group is si...
ra
- May 25th, 2007
A record group is an internal Form Builder data structure that has a column/row framework similar to a database table. However, unlike database tables, record groups are separate objects that be...
-
What is the built-in used to get and set lov properties during run-time?
Get_lov_property Set_lov_property Record Group
g_sidhu
- Feb 14th, 2008
/*** Built-in: SET_LOV_PROPERTY ** Example: if LOV is currently base on GROUP1, ** make LOV use GROUP2 */ DECLARE lov_id LOV; BEGIN lov_id := Find_LOV('My_LOV_1'); IF Get_LOV_Property(lov_id,GROUP_NAME) = 'GROUP1' THEN Set_LOV_Property(lov_id,GROUP_NAME,'GROUP2'); ENDIF; END;
g_sidhu
- Feb 14th, 2008
GET_LOV_PROPERTY: Returns information about a specified list of values (LOV). You must issue a call to the built-in once for each property value you want to retrieve. /*** Built-in: GET_LOV_PROPERTY *...
-
What is the built-in used for showing lov at runtime?
Show_lov
g_sidhu
- Feb 14th, 2008
The SHOW_LOV built-in is also used to display LOVs, but its functionality is slightly different from that of LIST_VALUES. It does not require that the LOV be attached to an item and it allows you to c...
Oracle Forms Interview Questions
Ans