• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 552
  • Last Modified:

CDG-01170

CDG-01170 when I generate some modules migrated from 6.0

Oracle Designer 6i
Oracle Developer 6i with patch 1 installed

We have table A, B and C. Table C is a child table of parent table A and B. The 2 Fks of table C are part of a mandatory arc.

If you try to generate a module having the master-detail components "A and C" or "B and C" you will get error CDG-01170.

We have many modules like that, migrated from Oracle Designer 6.0. There were no problems in Oracle Designer 6.0.

In Oracle Designer 6i I need to remove the arc to make it works.

Is this a bug or a new behavior ? We need to know before performing the official migration to 6i.
0
krishbest
Asked:
krishbest
  • 2
1 Solution
 
bestoracleexpertCommented:
Hi,

You cannot have mandatory ARC relationship, the FKs should be optional. Check the FK property in the child table.

Tried this steps,

Designer 6.0 ,

1. Created P1 and P2 tables with child CH1 table,
P1 and P2 have arc relationship with CH1. set the validate FK =client,

2. Created form module based on P1 and CH1 ,
Generated form based on default template/olb and default settings,
This generated fine and was able to insert into CH1 table,

3. Migrated the application into 6i,
No discrepencies found,
Was able to generate the form based on default template/olb and the form behaved the as in 6.0 ,

Didnot get CDG-1170 error in 6i,

Confirm if I am missing something,

There are no problems logged on this issue using ARC and 6i is expected to behave the same as in 6.0 ,


0
 
ramaswamymorlaCommented:
Hi,

You cannot have mandatory ARC relationship, the FKs should be optional. Check the FK property in the child table.

Tried this steps,

Designer 6.0 ,

1. Created P1 and P2 tables with child CH1 table,
P1 and P2 have arc relationship with CH1. set the validate FK =client,

2. Created form module based on P1 and CH1 ,
Generated form based on default template/olb and default settings,
This generated fine and was able to insert into CH1 table,

3. Migrated the application into 6i,
No discrepencies found,
Was able to generate the form based on default template/olb and the form behaved the as in 6.0 ,

Didnot get CDG-1170 error in 6i,

Confirm if I am missing something,

There are no problems logged on this issue using ARC and 6i is expected to behave the same as in 6.0 ,
0
 
krishbestAuthor Commented:
Can you tell me a test case?
0
 
krishbestAuthor Commented:
Can you tell me a test case?
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now