Re: database triggers & form triggers

see the block property 'DML Returning Value' (which requires the block be based on a table in a database that supports the RETURNING clause)

-- 
Mark C. Stock
email mcstock -> enquery(dot)com
www.enquery.com
(888) 512-2048


"M Hamilton" <mhamilton_at_usgs.gov> wrote in message
news:7ce65461.0311121432.20401f7c_at_posting.google.com...


> I am working in Designer 6i creating forms.  I have created a before


> insert db trigger that executes a function which returns a derived

> name for the column ITEMNAME.  The trigger has been placed on the

> table, ITEMS_GDAPS.  It is activated when the user tries to save the

> data in a form.  This trigger and function are working because I have

> checked the database to see that the derived name has been added.

> However, I want to see this derived name in the form where the

> ITEMNAME column is displayed.  It is not showing up. ARGUUHH! I can go

> out of the form and come back in, or do a requery and the derived name

> data previously created will then show up in the ITEMNAME column.

> But, how can I get this column to display the trigger's derived name

> without doing a requery?  The following is my trigger code.  Any help

> would be greatly appreciated.

>

> CREATE OR REPLACE TRIGGER "INSERT_NEW_NAME"

> BEFORE INSERT ON GDAPS.ITEMS_GDAPS

> REFERENCING NEW AS NEW OLD AS OLD

> FOR EACH ROW

> begin

>     if :new.geographic_extent is not null and

>        :new.spatial_product_group is not null

>     then

>        :new.itemname :=

> function_itemname(:new.geographic_extent,:new.spatial_product_group);

>     end if;

> end;

>

> Thank you,

> Margaret