Re: Trigger in Forms 4.5
From: Joe Strano <jstrano_at_dulcian.com>
Date: 1998/04/06
Message-ID: <6gbl5s$4kp_at_bgtnsc03.worldnet.att.net>#1/1
Date: 1998/04/06
Message-ID: <6gbl5s$4kp_at_bgtnsc03.worldnet.att.net>#1/1
Check the field properties to ensure that Primary Key and Required are both FALSE. Also, I would suggest re-querying after commiting the form so that the form can get updated with the IPNET_IDs the database created.
-- Joe Strano Dulcian, Inc. ------------------------- Paul Kreis wrote:Received on Mon Apr 06 1998 - 00:00:00 CEST
> hello,
>
> I created a Trigger (pre-insert) in Sqlplus on my table (tb_ipnet). It
> should insert automatically (sequence) the ipnet_id. When I insert
> some datas in the sqlplus it works but when I want to insert datas
> in Forms 4.5 then it works not (Failure: field must be entered).
>
> I have the following Table
> tb_ipnet:
> ipnet_id (column with pre-insert Trigger and Sequence)
> ipnet
>
> Why must the field entered? Should I create a trigger in Forms 4.5
> also?
>
> thanks for help.
>
> --
> =================================================================
> Paul C. Kreis Informatiker Ascom
> Phone: ++41(0)31 999 6605
> paul.kreis_at_ascom.ch Natel: ++41(0)79 432 0514