I have KeyLinksAutoDefine checked, otherwise the Keylinks is empty.

Detail query is :
select ID (PK,FK)
, ROW (PK)
, DOCNO
, NAME
, REGNO
, AMOUNT
, ACCOUNT
, BANK
, (select name from bank where bank.swift=mass_detail.bank) as bankname
, BREF
FROM MASS_DETAIL
order by id,row
for update

FK is tied to master tables ID field, cascade in update and delete.
Should I put anything into Keylinks and KeyDescLinks? Is there troubles with
foreign key?

Riho-Rene Ellermaa
senior programmer
Hansabank

> Transaction is tiCommited, AutomCommit is false
> Detqail query's Masterlink is
> mass_detail.id=masspay.id
> both ID fields are generated by GeneratorLinks
> id=mass_gen

Just checking;

Are the keylinks on the detail dataset totally defined (not reliant on
the masterlinks at all). I remember some time ago I had something
strange happening and it was because I had setup the detail dataset
with KeyLinks that were only unique when combined with the
masterlinks. IBO requires that the KeyLinks represent a unique record
on their own.





[Non-text portions of this message have been removed]