Re: cannot insert into table

From: Arnold Schommer <aschommer_at_fs-edv.de>
Date: Fri, 04 Dec 1998 08:30:24 +0100
Message-ID: <36678F90.24AD2C44@fs-edv.de>

Krishna Subramanian wrote:
>
> I get the following error message when I try to insert a new record into a
> table (different from the table represented by the block) from a form:
> Quote
> FRM-40600: Record has already been inserted.
> Unquote
> I have the insert statement in a When-button-pressed trigger and is to
> execute when :system.record_status is 'Insert' or 'New'.
> The ID (primary key) is generated automatically and shows up on the screen
> when displayed. Values are provided for all NOT NULL columns.
> The insert statement works fine from SQL*PLUS. The insert statement is
> followed by a commit. (I have also tried commit_form).
> I would appreciate any help on this problem.
> Thanks.
> krishna

If this is an base-table block, you should not do the insert-statement yourself: only set the missing values within a pre-insert-trigger or so: Forms does the insert itself !
btw: the error you get seems to come from forms which should also show you that not your insert-statement is what goes wrong.

Hope it helps

Arnold Schommer Received on Fri Dec 04 1998 - 01:30:24 CST