Subject | Re: [IBO] BDE to TIBOTable : different behaviour when inserting on master detail |
---|---|
Author | Helen Borrie |
Post date | 2003-08-29T11:24:01Z |
At 08:43 AM 29/08/2003 +0000, you wrote:
I'll send through tonight.
TIBOTables, if you have primary keys on those tables. Records are not
editable without KeyLinks.
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).
"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
>Hello,Confirmed - it appears to be broken. I've made a test case for Jason which
>
> 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
I'll send through tonight.
>I have checked new properties in IBO like keylinks,These are used, but they are KeyLinks are set automatically for you with
>keylinksautodefine, but help files have no comment
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 worksConfirmed, 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