Delphi 2.0 -> 3.0 Master Detailed Relationships

Delphi 2.0 -> 3.0 Master Detailed Relationships

Post by Michael Bushb » Sun, 31 Dec 1899 09:00:00



Hi I have a Master->Detailed relationship database that is several
relationships deep. as shown below....

              Master
                   |
              Detailed (Master)
                                 |
                             Detailed ( Master)
                                                 |
                                             Detailed  etc...

Now this works fine under Delphi 2.0 just link up all the tables in the
object inspector and away you go. The problem is when I take the exact
same code and try and compile it under Delphi 3.0 I get the error
Message "Circular Referances not allowed". I have been through the code
and removed all referentail integrities and all secondary indexs apart
for the ones needed to link the tables "Foreign Key" to it's "Masters
Local Key" yet I still get this error. Can anyone Help? Are you limited
to a Single Master -> Detailed relationship under Delphi 3.0?

                  Thanks

Michael Bushby

 
 
 

1. Master / Detail Relationships with cached updates in Delphi 2.0

In Delphi 2.0, if I have two tables in a form with a master/detail
relationship, and if both tables with cached updates enabled, when I change
the key of the master table, the details remain with the old key.
If cached updates are disabled everything works just fine!
Please, if anyone knows how to solve this problem, reply me.

Thanks


2. VB 4.0 and ODBC API calls

3. Master->Detail->Detail Query Too Slow

4. Add new record to multi tables w/VB

5. setting up master/detail in Delphi 2.0

6. looking for an SQL talk

7. Different detail Index order within master-detail relationship

8. ado woes

9. Selecting from Master/Detail w/ Detail as columns of Master

10. Generating item numbers in a Master/Detail relationship

11. TQuery Master/Detail Relationship

12. Master/detail relationship using CRecordset

13. Appling updates for master/detail relationship