Re: Can anybody explain me on this

Quite simply, if you want to change the functionality of the form at runtime you have three options:

1. Change the form itself. This involves coding.
2. Change the code within a called library, again coding.
3. Change code within database procedures and functions, again coding.

All will involve the forms designer, if only to find out what database procedure is being executed.

Another idea I just thought of is to write database triggers on the the table in question so that when an insert takes place you can make perform DML on your own table.

Good luck!

--
Alan D. Mills

internetual_at_my-dejanews.com wrote in message <70k23d$stb$1_at_nnrp1.dejanews.com>...
>I have an "Oracle Application" (Oracle Manufacturing).
>One part of this module is "Define Item form" where we
>define all the item in the system.This form is associate
>with the MTL_SYSTEM_ITEMS table in Oracle Database.
>
>I just want to ask a basic question. How can I create
>a "form level trigger". I understand the database trigger.
>I ask this because:
>
>Let say the user entered an item name, before he/she save the
>data I want to do something on my own table (not oracle table)
>let say inserting data which value is coming from this form (ie
>the item name).
>
>Do I need to customize the form itself?
>
>Appreciate any guide.
>Oracle Junior
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Oct 21 1998 - 05:13:42 CDT