At 04:08 PM 29-01-02 +1100, Geoff wrote:

>...
>> Trying to Master/Detail link two TIBOQueries say for
>> table A and B on Keylinks = B.Field1=A.Field2
>
>> Please straighten me out :)
>
>Ahhh, thats what I get for trying to be smart and talk about
>components with which I am not familiar :-( I can now imagine
>something you need TIBOTable for when you are stuck with TDataset
>derivatives.

Well, that's looking at it from one point of view. Developers who know what they are doing with the Delphi VCL design dependent tables so that primary and foreign key names match if they know they'll be implementing master/detail.

OTOH, at the beginning my first IB project, we didn't know what we were doing, so we designed a complete set of naming standards that turned out to be useless for M/D. We set up the database before we started developing the applications. Maybe every BDE developer gets to do it once...

The lesson isn't that Delphi forces you to use TTables for M/D but that Delphi forces you to understand the effects of your data design decisions, even right down to the names you give to things in your database...


regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at www.ibobjects.com