Re: What generates FRM-41106 Cannot create record without parent?
From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 30 Jul 2005 10:11:15 -0700
Message-ID: <1122743450.23538_at_yasure>
>>Miggins wrote:
>>
>>>i know and understand that....am trying to determine were the code is
>>>that generates this error message. is it something generated implicitly
>>>by forms?
>>>
>>>
>>>Mark C. Stock wrote:
>>>
>>>
>>>>"Miggins" <mtproc_at_yahoo.co.uk> wrote in message
>>>>news:1122386902.219502.294610_at_g44g2000cwa.googlegroups.com...
>>>>
>>>>
>>>>>Each,
>>>>>
>>>>>Am getting this error from a form. I know what the error means am just
>>>>>wanting to know what generates this error. It is not coming back from
>>>>>the server as there is no referential integrity between the 2 tables on
>>>>>the server.
>>>>>
>>>>>What prompts forms to generate this error?
>>>>>
>>>>>Thanks
>>>>>
>>>>
>>>>FRM errors come from FORMS
>>>>
>>>>you apparently have a master/detail relationship and you are trying to
>>>>insert a new record into the detail block when there is no record current in
>>>>the master bloack
>>>>
>>>>++ mcs
>>
>>Yes. When Forms creates parent-child relationships between blocks it
>>writes triggers and procedures.
>>--
>>Daniel A. Morgan
>>http://www.psoug.org
>>damorgan_at_x.washington.edu
>>(replace x with u to respond)
Date: Sat, 30 Jul 2005 10:11:15 -0700
Message-ID: <1122743450.23538_at_yasure>
Miggins wrote:
> Yes i know that too....however where is the code that actually > generates the message....where is the code that does the check for > parent record? > > Cheers > > > DA Morgan wrote: >
>>Miggins wrote:
>>
>>>i know and understand that....am trying to determine were the code is
>>>that generates this error message. is it something generated implicitly
>>>by forms?
>>>
>>>
>>>Mark C. Stock wrote:
>>>
>>>
>>>>"Miggins" <mtproc_at_yahoo.co.uk> wrote in message
>>>>news:1122386902.219502.294610_at_g44g2000cwa.googlegroups.com...
>>>>
>>>>
>>>>>Each,
>>>>>
>>>>>Am getting this error from a form. I know what the error means am just
>>>>>wanting to know what generates this error. It is not coming back from
>>>>>the server as there is no referential integrity between the 2 tables on
>>>>>the server.
>>>>>
>>>>>What prompts forms to generate this error?
>>>>>
>>>>>Thanks
>>>>>
>>>>
>>>>FRM errors come from FORMS
>>>>
>>>>you apparently have a master/detail relationship and you are trying to
>>>>insert a new record into the detail block when there is no record current in
>>>>the master bloack
>>>>
>>>>++ mcs
>>
>>Yes. When Forms creates parent-child relationships between blocks it
>>writes triggers and procedures.
>>--
>>Daniel A. Morgan
>>http://www.psoug.org
>>damorgan_at_x.washington.edu
>>(replace x with u to respond)
- Please stop top posting
- I already answered that. You acknowledged that you knew it already. So why are you asking yet again?
Go to the form's Program Units entries in the Object Navigator:
Read the code of CHECK_PACKAGE_FAILURE Read the code of CLEAR_ALL_MASTER_DETAILS Read the code of QUERY_MASTER_DETAILS
When it calls a form's built-in ... follow the trail.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Sat Jul 30 2005 - 19:11:15 CEST