|Subject||Re: [IBO] KeyLinks and KeyLinksAutoDefine|
> I'm using KeyLinksAutoDefine = True to make a dataset editale (II assume by this that you are assembling the SQL in code. Given that,
> cannot set the keylinks myself).
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