Subject Re: [IBO] BDE to TIBOTable : different behaviour when inserting on master detail
Author Helen Borrie
At 08:43 AM 29/08/2003 +0000, you wrote:
>Hello,
>
> Migrating from BDE to IBO I have a problem with master-detail
>relation
>
>MasterTable with CODE field is linked to DetailTable GENRE field
>wich with BDE wizard give
>
>Detail.MasterSource = MasterTable DS
>Detail.MasterFields = CODE
>Detail.IndexFieldsName = GENRE
>
>when I insert a record in detailTable, GENRE field is populated by
>dataset
>
>and TIBO doesn't

Confirmed - it appears to be broken. I've made a test case for Jason which
I'll send through tonight.


>I have checked new properties in IBO like keylinks,
>keylinksautodefine, but help files have no comment

These are used, but they are KeyLinks are set automatically for you with
TIBOTables, if you have primary keys on those tables. Records are not
editable without KeyLinks.

>What should I do to make a populated insert in DetailTable ?

Well, you *could* wait until Jason fixes it -- or you could begin your
process of moving away from desktop-style development by re-implementing
your TIBOTables as TIBOQuery. Your structure gives you no choice but to
use a parameterised query for M/D under the TDataset model (TIBOQuery
emulates TQuery in this respect).


>When MasterFields and IndexFieldsName are the same, IBO works

Confirmed, it does. TIBOQuery behaves similarly when Delphi is able to
"auto-match" the keys on the basis of column identifiers.

Actually, I also tried the alternative way - using IndexName (the foreign
key index) instead of IndexFieldNames. It doesn't work either.

cheers,
Helen