It  fires  when a value in a field has been changed and the field status is changed  or  new  and  the   key has been pressed. If the field status  is valid then any further change to the value in the field will not fire the on-validate-field trigger.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 6th, 2006

On-validate field tigger will fire when ever cursor moves from that field to next field, so first key-next will fire then validate.

Answer Question  Select Best Answer

 using On-Message or On-Error triggers.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 6th, 2006

other then on-error trigger , you can use  exception also in that blockwith the help of a small procedure and alert you can populate the message and with raise_form_trigger_failure transaction can be controlled.

Answer Question  Select Best Answer

 No.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 6th, 2006

no you can not make two blocks with same name,not only block for same type of object you can not have same name.

Answer Question  Select Best Answer

Manoj Kumar

• Nov 24th, 2006

First on-logon then next ...

manish

• Sep 17th, 2006

pre-formwhen-new-form-instancepre-blockwhen-new-block-instancepre-recordwhen-new-record-instancepre-textitemwhen-new-textitem-instance

Answer Question  Select Best Answer

nagendra

• Sep 29th, 2006

Take the isolated relation ship

Answer Question  Select Best Answer

 POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD.KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD.

Nitin Gupta

• Sep 13th, 2006

ON-VALIDATE-FIELD -> KEY-NEXTFLD -> POST-FIELD -> POST-CHANGE

Answer Question  Select Best Answer

 It fires just before SQL * forms the current block.

prachi

• Sep 13th, 2006

That master detail trigger name is on-clear-details. so this trigger does not exist atleast in 6 and above versions. don'y know abt lower versions

Parimala

• Sep 5th, 2006

Hi, on-clear-block Trigger is an master detail trigger when Master-detail relation block is created and when the master block is cleared, on-clear-block trigger will fire and its functionality is dependent upon the Co-ordination properties of Master-detail block.

Answer Question  Select Best Answer

 Function  key  triggers  are  associated with individual SQL*FORMS function keysYou  can  attach  Key  function  triggers  to 10 keys or key sequences that normally  do  not perform any SQL * FORMS operations. These keys referred as key F0 through key F9.

priyank74

 Profile Answers by priyank74 Questions by priyank74

• Aug 30th, 2006

Function Key Triggers - are associated with individual Runform function keys. A function key trigger fires only when user presses the associated function key. The action defined in Function Key Trigge...

Answer Question  Select Best Answer

kaye

• Aug 22nd, 2006

You have to use oracle SCM that goes with the designer.

Answer Question  Select Best Answer

Siddhartha Doshi

• May 30th, 2006

Hi,These are libraries attched with the Template.fmb to support the menu, Toolbar, and other required standard behaviors.RegardsSiddhartha

Answer Question  Select Best Answer

 INP (Source File)   FRM (Executable File)

parash_3380

 Profile Answers by parash_3380 Questions by parash_3380

• May 4th, 2006

Hiit create two files with extension FMB - Contains source codeFMX - It is executable file.

Amit Chintawar

• Mar 29th, 2006

FMB- You can open this fileFMX- This is in Executable mode, you cannot open this file

Answer Question  Select Best Answer

 No.

narayanapv

 Profile Answers by narayanapv Questions by narayanapv

• Apr 24th, 2006

Yes, we can change the default value of The Radio Button

xyz

• Mar 3rd, 2006

Yes

Answer Question  Select Best Answer

      Boilerplate Images     Image_items

Ravi

• Apr 3rd, 2006

For storing images in oracle we can use either CLOB or BLOB defined objectes, once the table is created with CLOB or BLOB data type, we can store images or documents or any junk into it. ThanksHRavi

Answer Question  Select Best Answer

 These triggers are executes when inserting, deleting and updating operations are   performed  and  can  be  used  to  change  the  default  function  of insert, delete or update respectively. For  Eg,  instead  of  inserting  a  row  in a table an existing row can be updated in the same table.

raji

• Mar 31st, 2006

Hi Triggers are like stored pocedure consisting of batch of sql statements. ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS attached to the respective tables get fired when the tables gets manipulated by the query containing DML statements and checks for business logic inside the trigger object.

Answer Question  Select Best Answer

akgorantla

 Profile Answers by akgorantla Questions by akgorantla

• Mar 24th, 2006

oracle Forms:-Oracle Forms are normal forms which are developed with Oracle forms tool in client side. oracle Apps Forms:-Apps forms are used in serverside oracle applications.if u want...

Answer Question  Select Best Answer

 SQL  *forms  is  4GL  tool  for  developing  and  executing;  Oracle  based interactive application.

 No.

kISHORE

• Aug 17th, 2005

Yes  By creating a Visual Attribute  And Assign the Visual Attribute in SET_ITEM_PROPERTY

Answer Question  Select Best Answer

 False.

 On-validate-field  trigger  fires,  when the field Validation status New or changed.Post-field-trigger  whenever  the  control  leaving form the field, it will fire.

 Post-field trigger fires whenever the control leaving from the filed.Post-change trigger fires at the time of execute-query procedure invoked or filed validation status changed.