Jason, I have use it with no luck.

When I use KeyFields AutoDefined, and do a simple select in a table choosing the table Primary Key, I thougth that IBO will detect a Primary Key and use it, instead of cretating the field ID_KEY. Am I rigth?

Example:

Table (
A_ID PrimaryKey
A_XX OtherField
)

If the Query is SELECT A_ID,A_XX FROM TABLE what will IBO do when KeyLinksAutoDefined=True? Generate a Field ID_KEY or use A_ID as primary key?

In this small example I have ID_KEY in the KeyFields array, after Prepare.

Artur

----- Original Message -----
From: Jason Wharton
To: IBObjects@yahoogroups.com
Sent: Tuesday, October 30, 2001 8:51 PM
Subject: Re: [IBO] KeyLinks AutoDefine


Use the KeyFields array.
You actually get an array of TIB_Column objects for the KeyLinks columns
that are in use.
If there are no actual columns then it fabricates an integer column and uses
an arbitrary value.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com


----- Original Message -----
From: "Artur Anjos" <arsoft@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, October 30, 2001 9:48 AM
Subject: [IBO] KeyLinks AutoDefine


> If I set KeyLinks to 'Autodefine', how can I get the name of the Field
that IBO is using for KeyLinks?
>
> The property KeyLinks always shows 'DB_KEY', even if IBO is smart enough
to find a better one.
>
> Artur
>


Yahoo! Groups Sponsor



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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