Re: Forms: master-detail problem (primary/foreign key)
Date: Thu, 26 Jul 2001 01:13:28 GMT
Message-ID: <Y8K77.15716$MC1.3593401_at_news1.elcjn1.sdca.home.com>
[Quoted] "Stefan Röhle" <roehle_at_mail.uni-mainz.de> wrote in message
news:3B5ED3FA.3F90AE53_at_mail.uni-mainz.de...
> Hi,
>
> I am currently developing an application with Form Builder (Version
> 5.0.6.8.0).
> On one canvas I use a master table and two detail tables.
> These tables are connected by an ID, which is the primary key of the
> master table and a foreign key of both detail tables.
> When I try to save (commit_form) the data entered into all tree tables I
> get the error ORA-02291: Primary Key not found (or similar, the original
> message is in German...)
> This indicates (I guess) that Forms tries to insert the detail data
> first and of course then the error is quite normal.
> How can I change the order in which Forms "saves" (insert or update) the
> changes?
> Or perhaps I have missed something else?
Are you using the master-detail relation properties in Forms itself or are you managing the blocks manually (w/o using the built-in relation functionality)?
-Matt Received on Thu Jul 26 2001 - 03:13:28 CEST