Subject | Re: [IBO] More info |
---|---|
Author | bemmel2003 |
Post date | 2003-06-10T13:41:10Z |
Helen,
the masterkey is generated and the generatorlink is filled. It works
all right. After inserting a master I get the generated ID at once.
My masterquery is a "multi-table-query"
SELECT TABLEA.*, TABLEB.NAME
FROM TABLEA INNER JOIN TABLEB ON TABLEA.NAMEID = TABLEB.ID
ORDER BY TABLEA.NAMEID
Keyrelation := TABLEA
My detailquery is:
SELECT *
FROM TABLEDETAIL
WHERE REFID = :ID ORDER BY ID
Leon
the masterkey is generated and the generatorlink is filled. It works
all right. After inserting a master I get the generated ID at once.
My masterquery is a "multi-table-query"
SELECT TABLEA.*, TABLEB.NAME
FROM TABLEA INNER JOIN TABLEB ON TABLEA.NAMEID = TABLEB.ID
ORDER BY TABLEA.NAMEID
Keyrelation := TABLEA
My detailquery is:
SELECT *
FROM TABLEDETAIL
WHERE REFID = :ID ORDER BY ID
Leon
--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 12:19 PM 10/06/2003 +0000, you wrote:
> >string-key
> >After detail-insert I immediately see the master-key in my
> >detaildataset
> >
> >integer-key (not null)
> >After detail-insert My masterkey-fields remains empty
>
> Is the master's primary key being filled by a generator? If so, do
you
> have the master's GeneratorLinks property set up?
>
> Helen