At 11:33 AM 11/04/2004 +0200, you wrote:

>Dear Helen
>I deduce from your remark, that you prefer Key links.

Adrian,
You deduce wrongly. It is not a question of Params versus Keylinks (as
your Subject seems to assume).

But the Keylinks of the master allow the detail to "find" the input
parameter from the datasource when the master-detail relationship involves
non-matching key names. (This isn't an issue with M/D in the native IBO
data access, only with TIBO, which is stuck with TDataset's very poor
implementation of M/D for queries....)

That's not all the Keylinks are used for, of course.

>My program was ported from DBAse in 1999, and has a datamodule that will
>give anybody a headache.

So, have you been using a very ancient version of IBO?

>Many, many queries, and I used params in the past, and generators for
>the keyfields (ID's). So it will be a major rewrite, but perhaps worth
>it.

I don't think we are understanding each other...at all...

>I find it difficult to set up the key link logic in the Queryeditor.

There is nothing to "set up". The Keylinks are a set of field in the
dataset that uniquely identify a dataset row. The Keylinks property is a
stringlist: you put the field names (usually it's the columns of the
primary key) one beneath the other in the TMemo that is used for the
Keylinks editor with the TIBO datasets.

>Any advice in this regard, and will the conversion be worth an increase
>in performance.

I don't know. I have no idea what you have now...

>My database is 500MB big, with some of the tables with over 4.5million
>entries.
>

It's not the table size that matters. It's what you do with them....no
ideas about that whatsoever.