Subject Re: [IBO] KeyLinks and KeyLinksAutoDefine
Author TeamIBO
> I'm using KeyLinksAutoDefine = True to make a dataset editale (I
> cannot set the keylinks myself).

I assume by this that you are assembling the SQL in code. Given that,
then there is no reason why you cannot define the keylinks yourself,
using a variation of the GetKeyLinks code that you have provided.

Get the list of key fields
IB_Connection.SchemaCache.GetTableKeys( TableName, tmpStrList );

then see if all field names in tmpStrList are in the fields you are
placing in the select clause. If so assign tmpStrList to KeyLinks, if
not then put the DB_KEY into the keylinks yourself.

--
Geoff Worboys - TeamIBO
Telesis Computing