krishna

• Dec 20th, 2014

First WHEN-VALIDATE-ITEM and then next KEY-NEXT-ITEM

Ram Mohan

• Apr 8th, 2013

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

Answer Question  Select Best Answer

Illustrate a scenario where post change and pre-change trigger get fired?

raaj

• Jan 15th, 2015

I am unable to find pre- change trigger

ajaz_11i

 Profile Answers by ajaz_11i Questions by ajaz_11i

• Jun 24th, 2008

pre-change trigger fires when the value is changed or selected from the listitem andpost-change trigger fires when the value is changed after the value is selected from the list item.BY Mr. Aijaz Ahmad Kumar    D2k Expert

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

vinod_ce2005@hotmail.com  

 Profile Answers by vinod_ce2005@hotmail.com Questions by vinod_ce2005@hotmail.com

• Member Since Dec-2005 | Dec 29th, 2005

---

by using run_product we can call report from a form

kamaraj

• Feb 12th, 2015

Guys always give correct answer cz people think its correct

Using run_product(6i),run_report_object(10g)
set_report_object_property(repid,report_other,paramform=no) using this we can hide parameter form

radhika

• Apr 28th, 2012

We can call report from form directly from object navigator of form

Improve Answer

some tell me code to attach SecuGen thumb device and scan and handle attendance in form 6i.i'll be thank full....

Azhar Hussain

• Apr 27th, 2015

1.These devices use different DLLs to communicate with device , call these DLL in Oracle Forms.

2. Some time OCX controls are also available to communicate with devices

Answer Question  Select Best Answer

Is It possible to use or develop grid in oracle d2k? if possible means how?

Sandeep

• Aug 23rd, 2016

Drag and drop one item on your canvas and set its block "no of records displayed" property to more than 1 then the block should look like a grid.

Answer Question  Select Best Answer

Hancock

• Jun 15th, 2017

You can develop the queries by using report builder as
1.SQL
2.JDBC
3.OLAP
4.Text
5.XML
6.Ref

Naushad Hassan

• Feb 3rd, 2017

SQL, PLSQL(REF CURSOR), XML QUERY

Answer Question  Select Best Answer

Hancock

• Jun 15th, 2017

You can change the page size dynamically at main section page
go to object navigator and click paper layout and then 3 objectives can be populated you have to click the main section two time then property inspector layout can be populated there you can change the width

Muhammad Farooq

• Apr 27th, 2017

Please guide how to use this parameter PAGESIZE
as I am trying but not working as below
PAGESIZE = 17*8 ;
this line wrote in before report trigger but showing error

Answer Question  Select Best Answer

I am using Oracle forms. I want to know how to determine which tab the user is on in run time. For Example : I created 4 tabs in my canvas A,B,C,D. During run time, how do I get to know that which TAB is accessed by the user currently?

kamaraj

• Nov 2nd, 2017

Using get_item_propery you will get tab name
and display it

Answer Question  Select Best Answer

In D2k 11g, while generating the report from the URL How to save the generated text / PDF file to Local Machine automatically while running the report?

What is the advantage of using Program units procedure over database procedure? What scenarios do we use program units procedure over database procedures?

kamaraj

• Dec 16th, 2018

Forms program units are local to form builder if you want to use without database you can use form program units else use database procedure

Sandeep

• Aug 23rd, 2016

Program unit procedures can be used when forms items (fields, data blocks) needs to be accessed. Otherwise it is better to use database procedures.

Answer Question  Select Best Answer

kamaraj

• Dec 16th, 2018

Datablock -->property set query data source multiple table like(emp,dept) & where clause property join 2 tables like(emp.deptid=dept.id)

Sandeep

• Aug 23rd, 2016

Database Block can be based on more than one table. Query data source name: table names. Where clause: join query. The advantage of joining tables in your block is that the result set is faster than t...

Answer Question  Select Best Answer

kamaraj

• Dec 16th, 2018

When-validate-item
key-next-item
post-change

kamaraj

• Dec 16th, 2018

1) Pre-logon
2) On Logon
3) Post logon
4) Pre-form
5)When-new-form
6) pre-block
7)when-new-block-instance
8)when-new-item-instance
9)when_validate_item
10)Key_next_item
11)post_text_iem
12)Post-block
13)post-form

Answer Question  Select Best Answer

KAMARAJ

• Dec 16th, 2018

Bind refrences uses :varname
lexical refrences uses &varname in sql statement

kamaraj

• Dec 16th, 2018

Key next item trigger fires when we move next item(key board events such like tab or enter), it ill not fire when we click mouse to another item.

Answer Question  Select Best Answer

kamaraj

• Mar 24th, 2019

Stacked canvas is load above content canvas, which is used for popup windows. We can show additional details for example if you want to show the customer details while click details button.

vishnu

• Jun 1st, 2015

How to create the stacked canvas.....please try to give me the brief idea about my requirement...In that you need to have two different canvases in one form. First canvas should show only semesters wi...

Answer Question  Select Best Answer

Can :SYSTEM.CURRENT_BLOCK value be changed. If yes how? If no Why?With Example

kamaraj

• Mar 24th, 2019

We cant change built in procedure values, its pre defined

zahir

• Sep 11th, 2013

No we cannot change system variable.

Answer Question  Select Best Answer

KAMARAJ

• Mar 24th, 2019

We cant handle the record one by one because it returns a result set

Pradeep

• Sep 23rd, 2014

If the number of records returned by cursor is more, it results in a performance issue. It is advised to use collections in this case.

Answer Question  Select Best Answer

kamaraj

• Mar 24th, 2019

In Oracle reports only 2 parameters
1. Bind parameter replaces single value in SQL, it is prefixed with :symbol
2. Lexical parameter replaces a statement in SQL, it is prefixed with &symbol

amruta shinde

• Aug 5th, 2014

Bind variables are used for replacing the single parameter in the select statement, where as Lexical Parameter is used to replace the where, order by conditions at run time

Answer Question  Select Best Answer