In the sequence of fired trigger which one is fired first i) when _validate_item ii) key_next_item?
Can we add scroll bar at on all tab pages in a single canvas? If yes then how:
If still couldnt see the scroll bar, just look at the x and y coordination of the scroll bar. Change the values of hose two according to the size of the window. You will see the scroll bar on the canvas.
You can add whatever scroll bar to your form. Normally we add scroll bars to the data block. Therefore no matter whether the canvas is content or stack or tab one. Simply you can add a scroll bar to y...
Answered by: vinod_ce2005@hotmail.com
View all answers by vinod_ce2005@hotmail.com
Member Since Dec-2005 | Answered On : Dec 29th, 2005
by using run_product we can call report from a form
we can call report from form directly from object navigator of form
By Using the key word RUN_PRODUCT
How to create grid in Oracle d2k?
Is it possible to use or develop grid in Oracle d2k? If possible means how?
How to use single data block to query multiple tables
Create a view on multiple tables and after then
Create a data block on that view
Use Post_Query Trigger on the Block Level.Remember in this Trigger if you are getting the data from the base table (your Data Block Source), then you dont need any coding.If you want to query another ...
Give an example for open_form with parameter passing from one form to another form?
call_form(file namw with path,no_hide,do_replace,no_query_only);
Code
HIDE_WINDOW('WINDOW1'); CALL_FORM('this u r file save path',NO_hide,no_replace,no_Query_only); SHOW_WINDOW('WINDOW1');
If you write null in on-error trigger defined in form level of forms 10g, then what will happen to the error message during runtime? Will the error message get displayed or not?
Dear All, Basically when we write null on on error then at that time, no error will display. At the backend when we want to search the on which packages are firing then write down ON_ERROR...
Nothing Happens... the on-error trigger wont be handled in case a NULL is written in the trigger
we can install two instance of oracle on a stand alone machine in two different directories and distinguish them by there different home names as orcl1,orcl2 we can work with both instances........
Yes, we can maintain two oracle databses in a single machine.
For this we need to install two Operating systems in your machine, one is Windows and another one is Unix.
After you that you should install the databases in the two Operating systems.
What triggers are actiVATed when master detailed relationship established?
1) On-Check-Delete-Master Fires when Oracle Forms attempts to delete a record in a block that is Master block in a master-detail relation 2)On-Clear-Details Fires when Oracle Forms needs to clear rec...
1) Which trigger are created when master -detail rela?1) master delete property * NON-ISOLATED (default) a) on check delete masterb) on clear detailsc) on populate details *...
How to convert a report into excel sheet
Hi Mr. Subrat, very good but when i set system parameters as destype=file and desformat=spreadsheet it is just showing on browser that "Successfully run" and nothing where as if i give destype=c...
set system parameters
destype=file
and
desformat=spreadsheet
(100% tested) and secure
Difference between flex,lexical and bind variable
Flex means to store the data for feature purpose.
Bind variable means it returns single column..
Lexical means it return multiple columns..
The main diff betn lexical and bind variable as followsBind reference will substitute a single value in PL/SQL whereas lexical variables are used to substitute multiple value. Bind va...
What are features of 4.5,6i,9i differencekindly list them
In 1992, Oracle version 7 was released with support for integrity constraints, stored procedures and triggers. In 1997, Oracle version 8 was released with support for object-oriented development a...
In 6i -> Report6i program units, layout modules, anchors, conflex and flex modes, frames and repeated frames.
By using FND_STANDARD.SET_WHO in PRE_INSERT and PRE_UPDATE trigger, 5 who columns can be populated. But this work in Oracle Application form customization.
In pre-insert trigger by using 'fnd_standard.who' package we can insert data into these two columns in Oracle forms.
Which property is used to define the relative position of one field with another
The property used to define the relative position of one field with another is Anchor
In properties -> Record -> Distance Between Records (Default value is 0).
Irrespective of number of records, between pages trigger will fire n-1 times.
Mittal, You are wrong. Page between trigger Fire only 4 times. If there is 5 pages in a report.
C.K.Ravi
3i-infotech
Opening new form and going to dept.deptno --pre-logon (form level) –post-logon (form level) –pre-form (form level) –pre-block (block level) –pre-record (block level) –pre...
Pre-form
When-new-form
Pre-block
When-validate-item
Post-block
A trigger is PL/SQL function which will fire whenever a corresponding event occures. The sequence of the triggers as follows
A trigger is PL/SQL block which will fire whenever a corresponding event occures. The sequence of the triggers are Key-Next-Item, When_validate_item, Post_item and when-new-item-instance.
Thanks,
Rahgu.
What is the return type for Oracle Apps report trigger
The return type for Oracle Apps report trigger is Boolean ie TRUE Or FALSE
That Will be Boolean like True or false
What are use of dde package in d2k
Oracle Forms for Microsoft Windows supports Dynamic Data Exchange(DDE), a mechanism by which applications can communicate and exchange data. DDE client support is a procedural extension to Oracle Form...
Sir can you tell me
any sites name where i can getproject in D2K
ajay singh
What is key.Next.Item trigger?
This trigger fires forces the cursor to be taken to the next available item or data block.
Key-Next-item trigger will fire whenver the user try to move the control(i.e., cursor) from one item to another item in the form by pressing return key or tab key.
Always first "key_next_item" firs first and then "when_validate_item" fire,this is applicable for all levels .i.e form level,block level and item level
key-next-item
when-validate-item